Forum Discussion

kezza04's avatar
kezza04
Frequent Visitor
3 years ago
Solved

Row Level encryption allow admin to see all

Hi  Loving the row level encryption.  Cannot figure out how to provide access to admin to see all of the data So I have a filter on a group for manager records and another on users records using "[...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

kezza04 , if user is workspace admin, the RLS do not apply. make the person workspace admin

 

or have code like

 

Switch( True(), [email] ="[email protected]" , true(),

[Email] = USERPRINCIPALNAME(), true(), false())

  • kezza04's avatar
    kezza04
    Frequent Visitor
    3 years ago

    Thanks.  this is not yet a cloud report so first idea won't work.

    I tried the switch statement exactly but that is not working either with no data showing for the admin user.

    • kezza04's avatar
      kezza04
      Frequent Visitor
      3 years ago

      The way I need it to work is if admin don't apply filter, else apply filter.  With the code you provided it seems to me the filter will always be applied?