Forum Discussion
Row Level Security - Conflicting Roles
Hi :) We are creating a few new pages to an exisiting report. Our exisiting report has row-level security based on the financial structures that they are allowed to view. This has worked well so...
Anonymous
You can have multiple roles in a model with different security filters assigned to each role. For the managers, if you create a role that has not filters applied then make the managers members of that role, they will see all the data. Or in the manager role you may want to apply a filter to the employee table where [manager email] = USERPRINCIPALNAME() so managers can see all the people under them.