Forum Discussion

Ben1981's avatar
Ben1981
Helper III
9 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
    9 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
9 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