Skip to main content
Version Data Integration and Analytics
Hitachi Vantara Lumada and Pentaho Documentation

Secure SQL filter function access

  1. Last updated
  2. Save as PDF
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

  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>

    NoteValues 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>

    NoteValues 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.

Results

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