Forum Discussion

NinnaN's avatar
NinnaN
New Member
3 years ago

Different RLS on different tables that have a relationship

Hey 

 

I have two pages with data from the HRP SKF table and two pages with data from the HRP SKF, HRPM SKF and HRPA SKF tables. I need corresponding RLS that only filters the hierarchy in the HRP SKF table on the two pages with only information from HRP SKF and I need RLS that filters the information from the HRPM SKF tabel on the pages with data from the three tables. 

 

I have the following data model:

 

I have a RLS table that does not have a relationship with the other tables. I have the following information to manage roles:

 

I have hierarchies in the HRP SKF table and the HRPM SKF table:

 

I have made the following security roles:

 

Right now I get the correct information on the two pages containing only information from the HRP SKF table when I test the security roles, but I am missing data from the pages containing information from the three tables. 

 

I hope that you can help with the problem, so that people only can see the information that is relevant for them. 

 

 

 

No RepliesBe the first to reply