Secure SQL filter function access

Pentaho Business Analytics

Version

9.3.x

Audience

anonymous

Part Number

MK-95PDIA004-13

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:

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:
```

<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:
```

<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 Pentaho Server with the start-pentaho script.

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