S

Supabase•4y ago

Ryann

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 ?