Secure SQL Access for Dashboards
The Dashboard Designer has an SQL filter that allows greater control over a database query. By default, this feature is restricted to administrative users. To change these settings, follow the instructions below:
- Ensure that the BA 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>
Note: Values 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>
Note: Values are separated by commas, with no spaces between user names. - Save and close the text editor.
- Restart the BA Server with the start-pentaho script.
The SQL filter function is now available in Dashboard Designer to the users and roles you specified.