RLS not allowing to read data
RLSI have two tables A & B. Table B has columns id, supabaseid ( auth.uid of user). Table A has id. I can allow a user to read only those rows in Table A where id of Table B is equal to id of Table A. So I created RLS policy
create policy "user" on "public"."organisation"
as PERMISSIVE for SELECT to authenticated
using (
(id IN ( SELECT B.id
FROM B
WHERE (B.supabase_id = auth.uid() )))
);
Unable to read data after the above RLS policy.
);
create policy "user" on "public"."organisation"
as PERMISSIVE for SELECT to authenticated
using (
(id IN ( SELECT B.id
FROM B
WHERE (B.supabase_id = auth.uid() )))
);
Unable to read data after the above RLS policy.
);
