Setting up row-level security

To set up row-level security (RLS), perform the following steps.

1. From the Toolbox, click Semantic Models.

2. Select the semantic model name from the list and click the Process tab if needed.

3. From Properties, scroll down to Data Security and choose one of the following as an endpoint source:

   • Kyvos Internal

   • CustomRLS: Displayed only if the corresponding JAR files are uploaded through Custom Data Security Configurations on the Kyvos Manager.

4. Select an endpoint.

5. Click the Define Rule and Mapping link and select Groups or Users and select the groups or users you want to use or use Search to find them.

6. For Rules, click Allow All Columns, Allow All Rows, or click the Plus sign next to Rules to add a custom rule. 

   Open

   

7. On the Add Rule dialog, provide Rule Name and Description. 

   Open

   

8. From the Row Level area, click the field link and select the field on which you want to apply the RLS.

9. Select the condition (And / Or) using the and link.

   Open

   

10. Click the value link, and the dialog box is displayed where you can search or select the values on which you can apply the RLS. The available choices vary depending on the data you are using.  

    Open

    

11. Click Add. The RLS is applied to the selected values. you can also apply RLS on the Key value when the Hierarchy/attribute contains description (display field).

12. Click Row Level, and then select the click the field link, and then select the field on which you want to apply the RLS security on key field.

    Open

    

13. The RLS on Key field is applied to the values.

    Open

    

Read more: