Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Row level security: Multiple users for one cost center

Hi.   I need to add row level security to a report showing costs per department. All departments have a manager, who should have access to data for the specific department. Furthermore, the finance...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi Anonymous ,

     

    You need to have your relationship with many-to-many with the filtering from the UserAcess to the CostCenter:

     

    Then this will work properly:

    File attached.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi MFelix 

 

I think I have done hwat you are suggesting, but it still doesn't work. I have added a test report to my question.

 

Thanks a lot.

 

MFelix's avatar
MFelix
Super User
2 years ago

Hi Anonymous ,

 

You need to have your relationship with many-to-many with the filtering from the UserAcess to the CostCenter:

 

Then this will work properly:

File attached.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MFelix .

     

    It worked perfecly - thanks a lot.