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.
Result
Not run
update lab_sandbox.tickets set status = 'closed' where owner_id = (select auth.uid()) returning id, title, owner_id, status
| Decision | Title | Fields |
|---|---|---|
| Not run | Login bug |
|
| Not run | Billing question |
|
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.