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  It seems DAX provided by you is not handling all the scenarios. I think we don't need to add 2 DAX in sales and user

 

I added only one DAX - 

 

and when I view it as 

 

I see all the data 

 

also check the file 

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

sayaliredij Thank you for the support but this doesn't handle the scenarios for the network users. For example, Justin below (UserID 4) should only see the first 2 rows of the table below, he shouldn't see the row with network name, Sparkling Socials.