Row level security (RLS)

Using row level security, you can restrict data that appears in search results and pinboards by group. Row level security (RLS) allows you to restrict a group’s access to table row data.

You do this by creating a rule that associates a filter with a group. When a group member searches, views an answer, or otherwise works with data, ThoughtSpot evaluates the rules and prevents the display of the restricted data. Users see only the data they are permitted to see.

How does RLS impact user interactions?

The security rules apply to objects shared with users individually or through groups they are a member of. The rules restrict the visible data when users:

  • view a table

  • view a Worksheet derived from the table

  • search for data in the Worksheet or table

  • view answers from restricted data - either that they’ve created or that were shared with them

  • interact with pinboards from restricted data - either that they’ve created or that were shared with them

Search suggestions also fall under row-level security. If a user would not have access to the row data, then values from the row do not appear in Search suggestions.

If you are using passthrough security for a Snowflake or Google BigQuery connection, search suggestions may not fall under row-level security. Note that passthrough security for Google BigQuery is in Beta and off by default in 7.0. When using passthrough security, ThoughtSpot builds the search index on the user who created the connection. This user may have less restrictive row-level-security, or may be able to see all data. Other users may be able to see search suggestions for columns or values they should not see. They cannot run queries on these columns or values, however. If you are using passthrough security, ThoughtSpot recommends you turn off indexing for sensitive columns.

Why use RLS?

RLS allows you to set up flexible rules that are self-maintaining. An RLS configuration can handle thousands of groups. There are several reasons you might want to use row level security:

Hide sensitive data from groups who should not see it

In a report with customer details, hide potential customers (those who have not yet completed their purchase) from everyone except the sales group.

Filter tables to reduce their size, so that only the relevant data is visible

Reduce the number of rows that appear in a very large table of baseball players, so that players who are no longer active are not shown except to historians.

Enable creation of a single pinboard or visualization, which can display different data depending on the group who is accessing it

Create one sales pinboard that shows only the sales in the region of the person who views it. This effectively creates a personalized pinboard, depending on the viewer’s region.


Related information