Forum Discussion
Helper IIRow Level Security - Giving Full Access To A Single Person And Limiting Everyone Else
Hi alee5210 ,
Perhaps you can assign Contributor, Member or Admin permissions to your boss in the workspace, and Viewer permissions to everyone else, then set up RLS and assign roles. Because RLS only works for Viewers, not Contributors, Members or Admins. So your boss can see the full content without being affected by RLS.
I suggest you refer to this post, the solutions in it can be a good solution to the problem you are encountering:
Solved: Row Level Security applicable to limited people wi... - Microsoft Fabric Community
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi alee5210 ,
Perhaps you can assign Contributor, Member or Admin permissions to your boss in the workspace, and Viewer permissions to everyone else, then set up RLS and assign roles. Because RLS only works for Viewers, not Contributors, Members or Admins. So your boss can see the full content without being affected by RLS.
I suggest you refer to this post, the solutions in it can be a good solution to the problem you are encountering:
Solved: Row Level Security applicable to limited people wi... - Microsoft Fabric Community
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.