Multiple RLS Policies
I have a contacts table with two polices,
- one with an organisation_id check
- two with a user_role check
I have tested that both of these work individually, but combined I guess it always gets a true with the organisation check and will load the data ignoring the role check. Is this normal behaviour?
I would like this to do the checks and if one returns false then it won't load the data, Or do i have to combine these into one Policy ?
- one with an organisation_id check
- two with a user_role check
I have tested that both of these work individually, but combined I guess it always gets a true with the organisation check and will load the data ignoring the role check. Is this normal behaviour?
I would like this to do the checks and if one returns false then it won't load the data, Or do i have to combine these into one Policy ?
