RLS in Workspaces

[Anonymous]

Hi, I have a business scenario where reports are shared in a workspace and there are 2 requirements to be met.

1. RLS needs to be implemented at a region level. ie North Regional Manager should only be able to see data of region 'North'. 

2. Along with that, he/she also be able to develop his own reports for his respective region.

Since all the reports should reside in a single workspace only, I am not able to achieve both functionalities together since RLS at a workspace level can only be applied to 'Read only' users which in turn cannot create their own reports.

Please help me solve it. @GilbertQ 

[GilbertQ · Accepted solution]

Hi there

When you apply RLS it will allow for the user to only see their data.

What happens if you allow the user to have Build Permissions when you deploy the App?

What I would do is to create another App Workspace where the user can leverage the shared datset, and the user can have the Member role?

This will still apply RLS to via the Shared Dataset and the user will be able to create reports in the NEW Workspace?

[Anonymous]

Thanks a lot @GilbertQ . This sounds like a good work around.

[GilbertQ]

Awesome, glad to help you!