Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How do I use Row level Security based on 2 tables?

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Under single role, you can apply filter conditions for multiple tables, one by one.

    Example click Employee table and apply the filter condition. [Dept]="Sales"

    Then click Location table and apply the next filter condition. [City]="Paris"

     

    Best Regards,

    Jay

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous The information you have provided is not making the problem clear to me. Can you please explain with an example.
    If you need OR, create two roles. If you need end add the rules in same role
    Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Under single role, you can apply filter conditions for multiple tables, one by one.

    Example click Employee table and apply the filter condition. [Dept]="Sales"

    Then click Location table and apply the next filter condition. [City]="Paris"

     

    Best Regards,

    Jay