How to setup RLS for two different key accounts under one role

[Balaraju]

Hi All,

I have one scenario I need to setup RLS for One role I wanted to see two key accounts under that particular role. Below screenshot showing some data. Just I wanted to create two key accounts under one particular role.

Eg: I have Created New role like Test under this role I wanted to keep two accounts A and B, if person selecting Test role he wanted to see A and B key accounts only.

Could you please help me out on this.

[v-xiaotang · Accepted solution]

Hi @Balaraju 

Thanks for reaching out to us.

please try this

(USERPRINCIPALNAME()= "test" && [Key account] in {"A","B"}) || (USERPRINCIPALNAME()<>"test" && [Key account] = USERPRINCIPALNAME())

sample data

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.