Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Issue with Row Level Security

Hello,   I have an issue in setting up a raw level security for my report. In my report I want to set a raw level security so each company can only see its sales in the report. Therefore, I created...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thank you all for your recomendations. However, the only way to give solution to this issue is to create a Dynamic RLS that solves the problem.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  Anonymous ,

 

Check whether there is a logical conflict between the new RLS expression relationship you created and the old RLS expression relationship.

For example, if a user has a condition, adding to another condition causes the user to exist in multiple roles, then these roles will conflict.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous thanks for your response. I checked for conflicts and I can confirm that there are no conflicts in these roles. I can see this after a check I did in our test environment when I leave only one role (so no chances for role conflicts) the issue still exists i.e. The RLS does not apply to the Group of Companies fields.