Forum Discussion
Bypassing RLS for a specific user for a particular tab/sheet
First of all it is not "page level security" - it is page visibility filtering based on RLS.
You either secure your data or you don't. There no such thing as "a little bit of security". Your request falls into that "a little bit" category.
Thanks for your reply. I understand about the need and intention for the RLS however my requirement is that the member of the lower heirarchy has some additional resposibilities where he will need to view the complete data and not restricted to just his in a particular tab. All other tabs works perfectly fine as per the business requirement and the RLS restrictions. This one tab should give complete access to this one user alone bypassing the RLS. Any workaround is much appreciated.
Change the RLS rules for all roles that user is a member of, or create a separate role just for them.
GilbertQ wrote a blog post on this using a combination of Row Level Security (RLS) and conditional formatting.
AnonymousThanks for the link. However my requirement is different. Lets take this example. The RLS applied restricts the users to see only his data. So every user has access to only his data in all the sheets based on the username( ). Now my additional requirement is I just want one user to be able to see all the data in a specific sheet irrespective of the RLS. The remaining sheets still restrics this user to see only his data but this one particular sheet should give him access to all the data. Any suggestions?
lbendlinI hope the above explanation helps you to understand the requirement better.