Forum Discussion
Link Sharing with Row Level Security
Just checking back in with the solution on this.
It turns out that we believe the users who reported the issue were actually seeing what they were supposed to see and just didn't realize it.
The reason the issue persisted in our internal testing is because we were removing people from the workspace just before assigning RLS and testing. We met with our Microsoft reps on this and it turns out that you need to wait at least 1 hour after removing someone from a workspace before assigning RLS. This has to do with a permissions job that runs hourly.
Thanks everyone for your help.
It still isn't clear to me what is going on. I ran a test yesterday with 8 users, 6 of which the RLS worked on and 2 it did not until the page was refreshed. These were users who have never looked at the report before and had never been granted access to the workspace. The link was provided by giving the users Direct Access and then creating a link for "People with Specfic Access" and emailing that link.
Why would RLS fail under these circumstances in 2 of 8? Isn't that a really big problem?
