Forum Discussion
Solved
Ignore RLS Path Hierarchy if Super User
Hi - I'm stumped on this one. I have a Path set up for RLS hierarchy in my organization but can't figure out how to stop using the path if the user is marked as a Super User. If they are Super User then I'd like for them to see all employee records.
This is what I have so far but I'd like to put a switch or If statement saying to disregard path if condition is met.
Hierarchy Path = PATH(data987654[Employee ID], data987654[Manager ID])
IF(
LOOKUPVALUE(
data987654[Super User],
data987654[AD Account],
USERPRINCIPALNAME()
)=1,
tRUE(),
[AD Account]=USERPRINCIPALNAME()
)
LOOKUPVALUE(
data987654[Super User],
data987654[AD Account],
USERPRINCIPALNAME()
)=1,
tRUE(),
[AD Account]=USERPRINCIPALNAME()
)
Your best bet would be to setup another role for the superusers where there is no RLS applied and just put them in that role.
1 Reply
Your best bet would be to setup another role for the superusers where there is no RLS applied and just put them in that role.