Forum Discussion

Ben1981's avatar
Ben1981
Helper III
10 months ago
Solved

RLS security not working

Hi,   Having trouble getting RLS working on my report.    I have two tables, one called HR Employees and the other is Managers. They are connected via a one way relationship from Manager to Empl...
Need Help
  • Ben1981's avatar
    Ben1981
    10 months ago

    I was able to solve the issue, I had done everything correctly and the initial user I had testing my data was originally a member of the workspace but I downagraded them to a viewer for for this test because I believed it should not have impacted the RLS as far as I know. However, it never worked for them and they were able to see all data.

    So, I found another test subject who was not a member or viewer of the workspace and I shared the report with them, they requested access which I provided and the RLS seem to work just fine for them. 

    So yeah a weird one but it works!

    Thanks,
    Ben

Ben1981's avatar
Ben1981
Helper III
10 months ago

Thanks but that is litterally what I've done with the one exception being my relationship between tables is one way, Manager to Employee. Anything else that I need to try?

danextian's avatar
danextian
Super User
10 months ago

Hi Ben1981 

Could there be other roles that override the manager filter? For instance, a role that grants access to all rows would take precedence over any manager-level RLS. Additionally, remember that RLS only applies to users with the Viewer role in the workspace. Users with Contributor or higher permissions will still see all rows.

  • Ben1981's avatar
    Ben1981
    Helper III
    10 months ago

    No other roles added, just the one for a manager and the person I'm using as a test subject is only a viewer to the workspace. I'm at a total loss, it should work! 😞