Skip to content

USING (true)

One permissive USING (true) policy is combined with the others using OR, so every granted row leaks.

Who is running the query

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

Result

Not run

select id, title, owner_id, amount, secret from lab_sandbox.invoices order by id

Policies and grants

SQL is allowed

Alice can read her invoice, including the secret. Bob's invoice stays hidden.