Skip to main content

Pentaho+ documentation is moving!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Secure SQL filter function access

Parent article
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.