Dear Experts,
Need help to implement the row level security by considering multiple columns from 2 tables.
I have two tables [ cost code & user info] from which i have to consider the columns to implement the RLS.
From Cost table user assigned to Level 1 cost code should have access until cost code level 4 and User assigned under cost code level 4 should have only access to level 4. User assinged * in the user info table should have access to all the data. current relationship between the tables are Many to One and single direction cardinality. Using Path function i am getting an error [[ The value 1123456 is missing from cost table. Please add the missing data and try again]]
| Cost table |
| Cost code level 1 | Cost code level 2 | Cost code level 3 | Cost code level 4 |
| 9928100000 | 9928101000 | 9928101110 | 9928101111 |
| 9932100000 | 9932105000 | 9932105230 | 9932105232 |
| 9786700000 | 9786708000 | 9786708440 | 9786708442 |
| 9876300000 | 9876301000 | 9876301760 | 9876301763 |
