Forum Discussion
RLS with org hierarchy
Anonymous , if their reportees is part of if they should get access to it.
I think the MBAS Gallary video they have even shown how to bypass it for a certain user. Saw it long back so not sure now. Even you can have a fact where you do no apply RLS and give access to the executive from that
Hi,
In this case you'll have to create 2 roles;
Role 1 - for managers/SVPs whose details are available in the shipment data. You can use pathcontains and username/userprincipalname to validate the user. Add managers and SVPs to this group in the RLS of dataset.
Role 2 - for Presidents whose details are unavilable in the shipment data. Just create a role without using security filter functions and add presidents to this group similarly.
This way Presidents have access to view all the data and managers/SVPs have access to view the data that they are entitled to.