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 "[Email] = USERPRINCIPALNAME()"

would like the admin to see all

 

 

Need Help

4 Replies

  • 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?