Forum Discussion
RLS row level security - not showing online
That's correct, it's just them being members that is causing RLS to be ignored.
First.....Thank you for your help!! It's already been super helpful as I'm going to be working all weekend on this report.
The workspace was automatically created via a Microsoft Team that was created. We have 5 sales teams that need to see the report...plus executives that want to see the total report. The 5 sales teams of course just need to see their areas...but the execs want to see the full report.
So, I could create a new premium workspace...or upload the report to another premium workspace that we have already that they are not members of...and then the RLS would work, correct?
Super UserThat's correct, it's just them being members that is causing RLS to be ignored.
- jdbuchanan71
You should also create and executive role where no filters are applied. With RLS enabled, if a user that is not in a role and is not a member of the workspace goes to view the report they will see nothing.
Or you could make the execs members of the workspace.
Thank you! Just tested it and everything is working properly at the team level.
I've seen some good tutorials on how to apply a "path" if I wanted to go from Manager...down to sales people...to see a hiearchy in the sales team. Will tackle that next.
I will mark this thread as solved!
That is great to know....as it is exactly a requirement I will have.