Secure SQL filter function access
The Dashboard Designer has a SQL filter for
greater control over a database query. By default, this feature is restricted to
administrative users.
Perform the following steps to change these settings:
Procedure
Ensure the Pentaho Server is not currently running; if it is, run the
stop-pentaho
script.Open the /pentaho-solutions/system/dashboards/settings.xml file with a text editor.
Locate the following line and modify it accordingly:
<!-- roles with sql execute permissions --> <sql-execute-roles>Administrator</sql-execute-roles>
NoteValues are separated by commas, with no spaces between roles.Locate the following line and modify it accordingly:
<!-- users with sql execute permissions --> <sql-execute-users>Administrator</sql-execute-users>
NoteValues are separated by commas, with no spaces between user names.Save and close the text editor.
Restart the Pentaho Server with the
start-pentaho
script.
Results
The SQL filter function is now available in Dashboard Designer to the users and
roles you specified.