Skip to content

Silent update

An UPDATE that can see no existing row changes nothing and raises no error. A SELECT policy is what makes the row visible.

Who is running the query

role authenticated · sub 11111111-1111-1111-1111-111111111111

Result

Not run

update lab_sandbox.tickets set status = 'closed' where owner_id = (select auth.uid()) returning id, title, owner_id, status

Policies and grants

SQL is allowed

UPDATE is granted and the UPDATE policy would allow Alice's row. There is no SELECT policy, so the row is not visible and the update matches nothing.