Forum Discussion
Row level security and relationship
Hello, I have this data model: relationship model: I want to use Row Level security via UserPrincipalName() expression. I have set up a role for table Employees: [UserPrincipalNam...
To be sure, I include a UserPrincipalName column in each table and set up a role filtering for each table. Also I eliminate the tables that cannot be enriched with UPN column (like Job Catalog) - data from such tables must be therefore merged+expanded to main datatables. Otherwise I cannot be sure that unwanted information will be hidden.
Thanks for your quick reply. But when we have a lookup tables it will be difficult to bring the UserName or UserPrincipal to lookup tables. I think I have a different issue, so I have created another thread here