Hello everybody! Hope someone can help me with this problem:
I have a table with various employee information, named Employees.
| Registration Code | Name | Area | Entity | Cost Center |
| | | | | |
I also have a table with HR BPs by service area/entity, named BP_Entity
| BP Name | BP Email | Area | Entity |
| name1 | name1@company.com | HR | People |
| name1 | name1@company.com | HR | Rewards |
| name1 | name1@company.com | HR | Benefits |
| name2 | name2@company.com | Logistic | Inboud |
| name3 | name3@company.com | Logistic | Warehouse |
| name4 | name4@company.com | Sales | Marketing |
Both tables are connected by the Entity column.
I created an RLS on the BP_Entity table using [BP Email] = Userprincipalname(), and managed to ensure that the BPs only see employees from their respective service entities.
But here's the problem. An Entity has several Cost Centers.
| Entity | Cost Center |
| People | 1111 |
| People | 2222 |
| People | 3333 |
| People | 4444 |
I need BPs to see employees from their respective service entities, but also all employees from the 1111 Cost Center, from the People entity.
How can I solve this situation?
Best Regards
