Forum Discussion
Row level security not working in web
I'm having this exact same issue. Has anyone figured out a solution? Works great in desktop but as soon as it's published the report breaks.
Hey cphilpotts - It turns out that I had a single user in two different security groups. I gave him access via his email to one security group (with global permissions), and he was also in a org wide user group (i.e. Mangers) that had limited permisisons within this specific data set. The two different sets of permissions conflicted with each other and threw up the error.
I resolved it by removing him from the Managers user group so that he was only in one RLS group via his personal email.
Not sure if this is the issue for everyone - I felt pretty silly when I finally resolved it.
I had the same problem and the solution wa to establish only one kind of secutity for every user.