Object-Level Security (OLS)

Object-level security (OLS) enables model authors to secure specific tables or columns from report viewers. For example, a column that includes personal data can be restricted so that only certain viewers can see and interact with it. For viewers that don’t have the required permission, it's as if the secured tables or columns don't exist.

Powerops simplifies the security role information by breaking it down into a user-friendly table, making it easy to comprehend and manage.

Currently, OLS can be configured using the external tool- Tabular Editor.

User Interface

1. Count of OLS Roles - View the number of OLS roles defined in the report.

2. Role Name - Shows the name of the security role

3. Description - Displays the description by the user about the role created

4. Table Name - Displays the name of the table on which the security role is created

5. Table permission - Set the permissions for the table to None or Read.

   None: OLS is enforced and the table will be hidden from that role Read: The table will be visible to that role

6. Column Name - Displays the name of the table on which the security role is created

7. Column Permission - Set the permissions for the column to None or Read.

   None: OLS is enforced and the column will be hidden from that role Read: The column will be visible to that role

8. Column Selector - Choose all the necessary columns to be viewed from the dropdown menu.

9. Download Button - Export the Row-Level Security (RLS) information in either CSV or Excel format.

10. Tables with OLS Not Configured - List of all table names where OLS is not configured