Skip to content

Missing grant

A missing GRANT returns 42501. A missing SELECT policy returns an empty result and no error.

Who is running the query

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

Result

Not run

select id, title, owner_id, body from lab_sandbox.documents order by id

Policies and grants

SQL is allowed

The owner policy is in place. authenticated has no SELECT grant, so Postgres stops at 42501.