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 transaction table, and the non-managers to see no data.

 

Would this be possible?

 

User table:

UserIsManagerEmailUsername
A0[email protected]domain\a
B1[email protected]domain\b
C0[email protected]domain\c

 

Transaction table:

Transaction IDValue
1100
2300
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()

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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()