Missing grant
A missing GRANT returns 42501. A missing SELECT policy returns an empty result and no error.
Result
Not run
select id, title, owner_id, body from lab_sandbox.documents order by id
| Decision | Title | Fields |
|---|---|---|
| Not run | Q4 plan |
|
| Not run | Hiring notes |
|
Policies and grants
SQL is allowed
The owner policy is in place. authenticated has no SELECT grant, so Postgres stops at 42501.