Forum Discussion

tod's avatar
tod
Frequent Visitor
5 years ago
Solved

Dynamic RLS - Works in Desktop but not in Service

I need help with implementing RLS. Sorry this is yet another RLS problem.   I created a test model in Desktop using 2 tables. First, called Security, contains 2 columns: UserID (to enter email) and...
Need Help
  • tod's avatar
    tod
    5 years ago

    It turns out that the "test as role" functionality in the service is buggy and inacurrate. I ended up taking a chance and releasing the reports to my community despite what "test as role" was showing as my last resort. And RLS worked, meaning the "test as role" view was wrong and misleading. Is there a way to submit a bug report? 

     

    Thanks again for your posts and guidance.

tod's avatar
tod
Frequent Visitor
5 years ago

Thank you for directing me to check in the build permission. None of my 4 test users have any permissions given at all, yet 2 of the test users can still see all data (no RLS filter applied), and 2 works as per RLS rules. 

 

I test this under the "security" selection, above "Manage Permission".

 

I checked to make sure the remaining 2 users were not members of the premium workspace and their names are not listed at all. 

 

Kinda stuck to search where else could their permission profile be overridding my dashboard that has RLS filter. 

 

For additional context, the premium workspace has over 50 existing dashboards, none of them have RLS, and all 4 test users have view access to several of the existing non-RLS dashboards.