Forum Discussion

merol007's avatar
merol007
Frequent Visitor
4 years ago

RLS for all tables

I had a question about the working of RLS about filtering through the whole model based on the userprincipalname. We have the following data model.       The RLS is applicable on table ‘aut...
Data Protection
Need Help
v-luwang-msft's avatar
v-luwang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi merol007 ,

Check the key point to note：

Now in order for this to work, you will need to apply the tick next to “Apply security filter in both directions”

NOTE: If this is not enabled or ticked the Dynamic RLS will not work correctly.

So once done it will now look like the following below (“Apply security filter in both directions” must be clicked):

  •  

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Lucien

merol007's avatar
merol007
Frequent Visitor
4 years ago

Hi Lucien,

 

Thanks voor your response. I did check the box 'Apply security filter in both directions' (see data model screenshot) but the filtering didn't work for the whole model. 

 

Regards,

Murat.