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:
- room_members is an array of the uid of authenticated users
- room_owner_id is the uid of the owner.
In the
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.
In the
USINGuid() IN room_membersbut it doesn't work.
A lot of example provided does not include this type of
USINGAnyone knows how to do this? Thanks!
