Forum Discussion

JVidal's avatar
JVidal
Icon for Helper I rankHelper I
6 years ago

RLS: Users with multiple roles filter problem

Hi all,    I have a model with Companies and Departments. My requirement is to create RLS for both Companies and Departments and assign them to users. Some users need to have both roles appliead at...
Need Help
JVidal's avatar
JVidal
Icon for Helper I rankHelper I
6 years ago

Hi, 

 

Thanks for the link, I will have a look. Perhaps I should have mentioned that the roles come from different dimension tables. So I have Companies in one table and Departments in another table.

 

Kind regards,

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

JVidal sure here is the blog post that specific talks about use business rules to apply RLS.

 

 

  • JVidal's avatar
    JVidal
    Icon for Helper I rankHelper I
    6 years ago

    Hi parry2k 

    I have read your post and I suspect you have all your data in 1 table and then your measure works, but if your filtering criteria is in different tables, I am not sure how to implement the measure.

     

    On the other hand, the example of your post is exactly what I want to avoid. I don't want users to see outside their company/department.

     

    So I have 3 case scenarios:

    - Users who can see the entire company -> No issues here (RLS to filter Company)

    - Users who can see Department for all the companies -> No issues here (RLS to filter Department)

    - Users assgined to a specific company and department -> Issue is here as the current setup of applying two RLS roles is not applying correctly, as it will show the entire company and Department for all companies. It looks like the filter is applied with an OR statement instead of and AND statement.