Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Row Level Security with OR condition

Hi,

 

In most of our model designs we have a structure like below:

Fact Table -> Dim Table - > Access table

 

There are different access tables based on different business areas, which connects to associated dimesion tables and then to Fact tables. We have dynamic RLS implemented on access table. This works fine.

 

But now in one of the scenarios, we have a structure as below

Here we are implementing 2 dynamic RLS on access table 1 as well as access table 2, but we do not want fact table to get filtered by AND condition of these two RLS, instead we need OR condition to give the results.

 

Let me know if anyone has implemented something similar, it would be really helpful.

Thank you in advance!

 

Regards,

Jyoti Pawar

Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Create two roles and use both of them, that will give or.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you for solution!

      But I still want to know if there are any more ways to do it.