Forum Discussion
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.