Row Level Security

The basic concept of Row Level Security is that the Username and Groups of a Tableau Server user are available in a variety of ways that can filter each query that Tableau makes, displaying only the data that the user should see. Tableau does not handle filtering data for an individual user using Permissions. Instead, this is implemented as Row Level Security either at the data source or workbook level.

Tableau Desktop has a “Create User Filter” option in the Server menu, but it is completely manual and hard-coded. For dynamic row level security that ties into a database or a security service, you’ll need to connect the user information to the data that exists somehow.

Currently (As of Tableau 10.5), the techniques implementing Row Level Security for Live Connections and Extracts differ.

Live Connection Row Level Security

There are several

The following go through the ways that individual level filtering (including hierarchical data filters) are implemented in Tableau:

How to set up your Database for Row Level Security in Tableau

Extract Row Level Security

Defusing Row Level Security in Tableau Data Extracts (Before They Blow Up) Part 1

Defusing Row Level Security in Your Extracts (Before They Blow Up) Part Two

Using Initial SQL to Pass Usernames to Stored Procedures or Views in SQL Server

Passing usernames and multiple values to a Stored Procedure using Tableau Server

Advertisements