Forum Discussion

JVidal's avatar
JVidal
Helper 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
parry2k's avatar
parry2k
Super 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
Helper 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.