RLS with no relationship

[nimp_kp]

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:

User	IsManager	Email	Username
A	0	a@mail.com	domain\a
B	1	b@mail.com	domain\b
C	0	c@mail.com	domain\c

Transaction table:

Transaction ID	Value
1	100
2	300

[amitchandak · Accepted solution]

@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()