Ignore RLS Path Hierarchy if Super User

[jimrosser]

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()
)

[jdbuchanan71 · Accepted solution]

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.