RLS policy 'in' not working
Hi,
I'm trying to add an RLS policy to allow SELECT operation on a table.
My table looks something like this
room_table:
where:
but it doesn't work.
A lot of example provided does not include this type of
Anyone knows how to do this? Thanks!
I'm trying to add an RLS policy to allow SELECT operation on a table.
My table looks something like this
room_table:
where:
- room_members is an array of the uid of authenticated users
- room_owner_id is the uid of the owner.
USING expression, I tried to do:uid() IN room_members but it doesn't work.
A lot of example provided does not include this type of
USING expression, so I have not had any luck getting the right way to do this. Anyone knows how to do this? Thanks!