Dynamic Row Level Security Flows acces

[ANM_97]

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 ~~!

[ANM_97]

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~~!

[lbendlin]

Please show your data model and indicate the RLS rules and where they are applied.