Skip to main content
Version Pentaho
Hitachi Vantara Lumada and Pentaho Documentation

Secure SQL Access for Dashboards

  1. Last updated
  2. Save as PDF
The Dashboard Designer has an SQL filter for greater control over a database query. By default, this feature is restricted to administrative users. To change these settings, follow the instructions below:
  1. Ensure the Pentaho Server is not currently running; if it is, run the stop-pentaho script.
  2. Open the /pentaho-solutions/system/dashboards/settings.xml file with a text editor.
  3. Locate the following line and modify it accordingly: 
    <!-- roles with sql execute permissions -->
<sql-execute-roles>Administrator</sql-execute-roles>

    Values are separated by commas, with no spaces between roles.

  4. Locate the following line and modify it accordingly: 
    <!-- users with sql execute permissions -->
<sql-execute-users>Administrator</sql-execute-users>

    Values are separated by commas, with no spaces between user names.

  5. Save and close the text editor.
  6. Restart the Pentaho Server with the start-pentaho script.

​​​​​​​The SQL filter function is now available in Dashboard Designer to the users and roles you specified.