Forum Discussion

JohnLow's avatar
JohnLow
Icon for Helper I rankHelper I
5 years ago
Solved

Row Level Security Question

Hi,   I'm new to RLS and need a little help. I've 3 tables Users, Network and Sales. Users has a relationship to Network which in turn has a relationship to Sales. Users have 3 roles: Network User,...
Need Help
  • sayaliredij's avatar
    sayaliredij
    5 years ago

    Hi JohnLow 

     

    Could you try applying a security filter

     

    I tried at my end and it works

     

    For Finance user - everything is visible and for network user - only data related to him

     

     

sayaliredij's avatar
sayaliredij
Icon for Solution Sage rankSolution Sage
5 years ago

JohnLow 

 

Could you check this file 

 

sorry I missed that the connection between Network and sales was one way

 

I enabled the following setting and then it worked

 

 

  • JohnLow's avatar
    JohnLow
    Icon for Helper I rankHelper I
    5 years ago

    sayaliredij , thanks again. I just realised that the relationship between network and sales is many to many. I should have been clearer in my model. I've attached the file again. Sorry for the confusion. 

     

    File