Forum Discussion
Dynamic Row Level Security Flows acces
Hello!
I have this problem:
I need to analyze the flows in the branches.
We have granted rights in table BRANCH_FLOW_ACCES so that each branch sees a certain flow.
Recently, one branch (branch d) was taken over by another branch (branch a). How can I give rights in the FCT_Flows table so that branch A can see its flows, but also those of branch D ?
| FCT_FLOW | ||
| FLOWS | BRANCH | STATE |
| FLOW 1 | BRANCH D | STATE 1 |
| FLOW 1 | BRANCH D | STATE 3 |
| FLOW 1 | BRANCH A | STATE 1 |
| FLOW 2 | BRANCH A | STATE 3 |
| FLOW 1 | BRANCH C | STATE 3 |
| DIM_FLOW | ||
| FLOW | STATE | STATE NAME |
| F1 | STATE 1 | Approved |
| F1 | STATE 3 | Finalized |
| F2 | STATE 1 | Approved |
| BRANCH_FLOW_ACCES | |
| BRANCH | FLOW |
| BRANCH D | F1 |
| BRANCH D | F1 |
| BRANCH A | F2 |
Thank you ~~!
2 Replies
Please show your data model and indicate the RLS rules and where they are applied.
Hello lbendlin !
This is my data model:
BRANCH_FLOW_ACCES = FCT_HO_USERRS_ACCESS
In FCT_HO_USERRS_ACCESS I associated user-level flows in table FCT_HO_USERRS_ACCESS.
My RLS need to be apply on FCT_FLOWS, because I need to give rights in this table so that branch A can see its flows, but also those of branch D.
Thank you~~!
