...
Row-level Security
Work in progress…
Tableau
Using Denodo
Most use cases should be able to use Denodo security by prompting users for credentials to connect to a Denodo data source in Tableau. This can be set when publishing a workbook to the Tableau server.
Now when trying to access that workbook, users will be prompted for their credentials and Denodo will apply RLS based on their privileges
...
Note that if you have multiple data sources, users will be prompted for credentials for each data source. Thankfully Tableau can remember passwords for each user and data source and it’s recommended that users do this.
...
Using Tableau User Functions
In the rare case where you need to implement security within Tableau, you can do so by filtering based on usernames, or an individual AD group.
Users
If you have a column named users
with comma separated user names like jdoe01,jdoe02,jdoe03
you check if a user existing in the like by creating a calculated field with the following formula:
Code Block |
---|
CONTAINS([users], USERNAME()) |
You can then create filter on your data for where this is True
.
AD Group
If you have a column named group
with a single AD group you can check if a user is a member by creating a calculated field with the formula:
Code Block |
---|
ISMEMBEROF([group]) |
You can then create filter on your data for where this is True
.
Tableau does not currently have an easy way to check for membership of multiple groups.
Other Tableau User Function can be found here: https://help.tableau.com/current/pro/desktop/en-us/functions_functions_user.htm