Forum Discussion

Balhemkan's avatar
Balhemkan
Helper III
3 years ago

RLS help

Hello Team,   I need your assistance on below issue.   I have master table which linked to fact table .we have values like below   Usershortname Email ID abc [email protected] bcd...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

Balhemkan , In the role, create the following condition

 

if([Usershortname] in {"abc","acd"}, [Email] = userprincipalname(), true()) 

Balhemkan's avatar
Balhemkan
Helper III
3 years ago

Hi Amit,

Is there any other way instead of manually entering users. 

Because we have too many users. 

 

  • azakir's avatar
    azakir
    Resolver I
    3 years ago

    Hi Balhemkan if you have active directory step up for your organization, you should be able to use that for this exercise instead of manually entering users. 

    • Balhemkan's avatar
      Balhemkan
      Helper III
      3 years ago

      Hi Amit, I have AD groups in organization but how it will help for RLS. Could you please explain little brief