Forum Discussion
Bypassing RLS for a specific user for a particular tab/sheet
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.
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.
You can give write access to dataset for that user and read, reshare access to dashboard. This will give him access to all data.
Do not allow reshare!
Tell your business users (in nice words) that their requirement makes no sense.
lbendlinWell I wish I could take business descisions. Anyways thanks for your time.
Anyone else with any idea or workaround for this requirement?
