Why doesn't an INSERT policy allow inserts?
Hi,
I'm trying to allow unauthenticated users to only INSERT into a table, and authenticated users to perform all actions (with a check on their user_id).
Right now I'm just trying to let unauthenticated users to INSERT. I've added an RLS policy for 'anon' role, for INSERT operation, with the USING expression just set to true. RLS rejects it.
However when I add the same policy for ALL operations, it allows the insert.
Why doesn't an INSERT policy allow inserts?
I'm trying to allow unauthenticated users to only INSERT into a table, and authenticated users to perform all actions (with a check on their user_id).
Right now I'm just trying to let unauthenticated users to INSERT. I've added an RLS policy for 'anon' role, for INSERT operation, with the USING expression just set to true. RLS rejects it.
However when I add the same policy for ALL operations, it allows the insert.
Why doesn't an INSERT policy allow inserts?
