Forum Discussion
Solved
RLS security
I have 3 tables: access - this table holds userid and access_id. each user has one row for each access_id he has access to. access_id is the foreign key for the tables t1 and t2 t1 - this table ho...
Great I've added some fake email addresses and used UserPrincipalName to apply the filter:
testrls - sam.pbixYou can impersonate an email by entering it into Other user and ticking the role you want to test:
hi,
Yes this works, thanks a lot 🙂
will this be usable on large datasets with million of records in the tables?
Should do, let us know how you get on!