Forum Discussion
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...
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
