Skip to content

Topic

Database privileges and catalogs

How a database decides which roles may see or modify which objects, and which system tables and views expose that metadata to the roles themselves.

Current clusters

build1 publisher

A Postgres role with no grants reads the FORCE flag on tables it cannot select from

PostgreSQL 18.3 handed a serving role with no grant at all on three tenant tables their exact owner and FORCE flags, in a dev.to author's test of three roles. The result gives an RLS setup check a third answer, UNDETERMINED, in cases where it would otherwise return a false nothing to report.

Publishers:dev.to

Reality

Evidence64
Adoption
Insufficient
Hype gap−10
Incentives25
Confidence60