RLS in Table reports

Understanding Row Level Security (RLS)

RLS is a powerful feature that allows you to restrict data visibility in reports based on user roles or attributes. This ensures that users only see the data relevant to them.

Sprinkle supports RLS for Table, SQL, and Model-based reports.

To apply RLS to a table report:

1. Create an RLS Attribute: Define an RLS attribute on the RLS page, mapping users to specific values. Refer to the detailed RLS documentation for more information.
2. Open the Report: Access the table report where you want to apply RLS.
3. Navigate to RLS modal: Navigate to the report’s “More options” menu and select “Row Level Security.”
4. Map RLS Attribute: In the RLS modal, choose the created RLS attribute and the corresponding column in your data from their respective dropdowns.
5. Apply RLS: Click the “Link” button to apply the RLS to the selected column.

Example:

• If you want to restrict sales data visibility to managers of respective countries, create an RLS attribute mapping managers to their countries.
• Then, apply this attribute to the “Country” column in your sales report.

Tip

Key Benefit: RLS applied to a column in a table report is automatically applied to all visualizations using that column in the same report, even if it’s in a different tab of the report.