Row-level Security

Scaling an embedded analytics deployment of Tableau often means providing content to different groups of users. There is a security implication of making sure the different groups do not see each others’ data (and metadata). There is also a deployment and maintenance consideration: Common dashboards should have to be built only once, even if the different groups of users access different data with those common dashboards.

Multi-tenancy, Sites, & Projects

The two key tools for defining which users can see which workbooks and datasources are Projects and Sites.

• Sites act as a logical firewall. If you create a site for each client or company that will access your Tableau content, you can be assured that users on one site will not learn about users or access content on another site.

• Projects (combined with Permissions) allow you to define which users inside the site can access which pieces of content. Permissions can be set at a granular level so that you can give different levels of permission to different users or groups.

If you have a multi-tenant deployment of Tableau Server, you should have one site per tenant. This is the only bullet-proof method of assuring different tenants do not learn about each other or see each others’ data. Projects should be used in addition to sites to give access to different groups inside of a company.

Row-level Security

Row-level Security is both a security and content management concern. The simplest way to make sure users only see their data is to manually build a dashboard for each of them. This is not scalable, so Tableau provides a variety of ways to build a single dashboard that is filtered to the correct data. The correct method to use depends on your data environment.

Here is some guidance (details for each of the methods are below):

• If you have a separate database for each tenant, build a template dashboard and use the Document API to clone the dashboard for each tenant.
• If your tenants share a database and there is filtering/entitlement logic to separate who should see which row, use user filters.
• Use Initial SQL + in-database security if you already have in-database security set up and plan on using live connections to the database

Template Dashboard + Document API

The Document API is a Python API for modifying and querying Tableau content files (TWB/TWBX, TDS/TDSX). If your data environment is such that each tenant has their own database (and they are each structurally similar), then you can use the Document API to create a single workbook for each of your tenants. The workflow is:

First, build a ‘template’ workbook that points at a single database. Build the necessary visualizations and dashboards. Then, create a script that:

1. For each tenant, uses the Document API to change the database connection information, and save a copy. Sample Script

The above is all that is necessary if your workbooks have ‘embedded datasources’ (the datasources haven’t been published separately). If you do choose to publish the datasources to take advantage of Tableau Server’s Data Server, the Document API will still work. You will just have to apply the above workflow first to the datasource(s) and then to the workbooks:

First, build a ‘template’ datasource, publish it, and build a ‘template’ workbook that points at the published datasource. Then, create a script that:

1. For each tenant, uses the Document API to change the database connection information in the TDS (datasource file), and save a copy.
2. For each tenant, for each workbook, uses the Document API to change the published datasource connection information, and save a copy.

User Filters

If your tenants ‘share’ a database server, and there is logic in the database that determines which users can see which rows, you can build your datasources and workbooks using ‘User Filters’ which is a way to filter based on which user is currently logged in to Tableau Server.

Essentially, when connecting to your data in Tableau Desktop you will JOIN the tables containing the data necessary for analysis to the entitlements table so that each row has a column (Owner in the below example) specifying which Tableau Server user it belongs to. Then you can create a calculation username() = [Owner] and filter to True.

See also

In-database Security and Initial SQL

If your database has existing security, such that setting the user to run the queries as will return the correct rows for that user, you can leverage that security with Initial SQL. Because this Initial SQL command will only run when queries are sent from Tableau to the database, this option only works for live connections to the database.

To use Initial SQL: When connecting to your datasource in Tableau Desktop, click “Initial SQL”. Type the correct command that will set all following queries to run as the logged-in user. For example, in Microsoft SQL Server, you might run:

EXECUTE AS USER = [TableauServerUser] WITH NO REVERT;

And now build your workbook normally. All sessions with the database will begin by running the Initial SQL that you specified.

See also