Forum Discussion
RLS with 4 levels
Hello,
We have an rls that currently works : a user connects to the internet portal with his "id_adh" and he can only see his associated tickets.
But now we want to set up two connection parameters :
- id_adh and 200 to see the id_adh level
- id_adh and 300 to see the city level
- id_adh and 400 to see the country level
- id_adh and 500 to drink the international level (equivalent to no RLS at all)
Example:
- I connect with "A2" and "200", I can only see the data associated with "A2"
- I connect with "A2" and "300", I can see all the "id_adh" data of "Manchester".
- I connect with "A2" and "400", I can see all the data of "United Kingdom"
- I connect with "A2" and "500", I can see all the data in the world (equal to no rls)
How can I modify my data model and/or configure my rls so that this works?
In advance, thank you very much for your help.
Here is the data used for this example :
1 Reply
- lbendlinSuper User
Change your table filter DAX expressions acordingly. They need to evaluate to True() for each of your scenarios.