Forum Discussion
Dynamic Row Level Security Based on Contract
Hi, I am trying to set up Dynamic Row Level Security for a large dashboard where each contract should only see their reporting metrcis. There are multiple people in a contract so I know it needs t...
Data is super sensitive.
In this case, how you you set up the formula in the manage roles?
In the Employees table:
[Email Address]=USERPRINCIPALNAME()
Right but I need everyone from the contract to be able to see it with many emails being associated with the same contract. I guess i am missing something.
Depending on the relationship between employees and contracts you can directly link the employees table to the contract table, or you use a mapping table that lists all employee-contract combinations.