Skip to content

Topic

Database Access Control

Authenticating and authorizing both human operators and programmatic callers against the same data store, including database roles and row-level policies.

Current stories

buildOne report1 publisher

Supabase ends automatic role grants on new tables in existing projects from October 30

Supabase stops auto-granting anon, authenticated and service_role on new tables in existing projects on October 30, an auditor writing on dev.to reports. Tables created after that need scoped grants in their migrations, since the common GRANT ALL TO public shortcut lets anonymous callers back in.

Publishers:dev.to

Reality

Evidence50
Adoption
Insufficient
Hype gap+10
Incentives55
Confidence55
buildOne report1 publisher

Missing Column GRANT, Not RLS, Blocked an Admin Balance Top-Up in Postgres

Postgres blocked a coffee shop's admin top-up at the column GRANT check before RLS ran, and a pg_proc scan found four functions built the same way. The error text does not say which gate refused, so when a correct policy still denies a write, check the grant first.

Publishers:dev.to

Reality

Evidence50
Adoption
Insufficient
Hype gap0
Incentives
Insufficient
Confidence55