Forum Discussion

Balhemkan's avatar
Balhemkan
Icon for Helper III rankHelper III
4 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
Icon for Super User rankSuper User
4 years ago

Balhemkan , In the role, create the following condition

 

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

Balhemkan's avatar
Balhemkan
Icon for Helper III rankHelper III
4 years ago

Hi Amit,

Is there any other way instead of manually entering users. 

Because we have too many users. 

 

  • azakir's avatar
    azakir
    Icon for Resolver I rankResolver I
    4 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
      Icon for Helper III rankHelper III
      4 years ago

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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Balhemkan , [Email] = userprincipalname()

    is way, but you have the condition to ignore, that is why hard coding

     

    How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk