Forum Discussion

nimp_kp's avatar
nimp_kp
Frequent Visitor
4 years ago
Solved

RLS with no relationship

Hi   I'm trying to implement RLS in a datamodel with no apparent relationship between the user table and the transaction table. I want all managers to be able to see all the data in the transactio...
General Comment
  • amitchandak's avatar
    amitchandak
    4 years ago

    nimp_kp , Create a new column in the transaction table and have value =1

     

    user type =1

     

    join this with IsManager (Many to many, Bi directional or use filter Fact)

     

    Then create role with filter on user table

    [Email] = userprincipalname()

amitchandak's avatar
amitchandak
Super User
4 years ago

nimp_kp , Create a new column in the transaction table and have value =1

 

user type =1

 

join this with IsManager (Many to many, Bi directional or use filter Fact)

 

Then create role with filter on user table

[Email] = userprincipalname()