Row Level Security - Conflicting Roles

[Anonymous]

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 far. 

Our new reports are to provide managers with user statistics, when was a user last logged on, are they active etc. These pages need different row-level security, they need a manager to be able to see everyone, and everyone else to just see their own statistics. However, a manager may not of been able to view the data the user was in, in the financial structure. So its almost like we need to cancel the row-level security on these few pages, and have a different row level security. 

Is anything like this possible? From my research it doesn't seem to be. 

Anna 

[jdbuchanan71]

@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.