row level security

[Anonymous]

Hello,

I have little experience with row level security.

I have create an RSL name OrgSecurity and I have implemented some rules which seems to work.

My question is how to create a RSL which permit to specif group user to bypass the Previous mentioned row level security

Ex: in active directory, GRP-SEC-CA...-BI contains the name of peoples of our BI team.

How can I create another row level security to permit the member of the BI team to bypass the rules associated to OrgSecurity?

Could you please provide an example.

Regards,

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

If you create another role that has no filters applied to it and add GRP-SEC-CA...-BI as a member of that role they will see the unfiltered report.

Also, members of the workspace ignore RLS so that is something to keep in mind.