Forum Discussion

zanottiluca's avatar
zanottiluca
Helper II
6 years ago
Solved

RLS Not Working

Hi guys,    I am setting up a Dynamic Row Level Security on the Employee table and having a simple model . The table Employees contains userprincipalname and is linked 1->M with the table History v...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    zanottiluca Pretty sure you do not want Both. You want the relationship direction to be defined as:

     

    Employees 1 -> * History

     

    Thus, security enforced on Employees limits the rows and this then flows to the History table via the relationship.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

zanottiluca - Right, the Both direction is if you would want History to filter Employees as well as Employees to filter History. To understand this, think of this scenario.

 

Place the "Employee" column from the Employees table in a table visual. Place a column from History in the same visual. Make the aggregation "count". You will get a count of the rows in the History table for each Employee. 

 

Now, create a table visual with the "Employee" column from the History table in a table visual. Place a column from Employees table in the same visual. Make the aggregation "count". You will get a count of ALL the rows in the Employee table for each Employee.

 

This happens because Employees table filters History but not vice versa.

zanottiluca's avatar
zanottiluca
Helper II
6 years ago

Thanks Greg , this indeed anwsers also to my DLRS question. 

Cheers
Luca