Postgres: prevent new user from creating tables, without superuser

Question

In Cloud SQL Postgres, where superuser permissions are not accessible, how can I prevent a new user from creating tables?

I know that REVOKE CREATE ON SCHEMA public FROM public works, but this seem to require superuser permissions, as I get a WARNING: no privileges could be revoked for "public" error.

Laurenz Albe · Accepted Answer · 2020-12-14 07:27:00Z

2

You have to run that statement as the user who owns public.

answered Dec 14, 2020 at 7:27

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Code Over a year ago

I see. The owner in the case is the superuser cloudsqladmin, which can't be accessed. Any way around that?

Laurenz Albe Over a year ago

Unless Google hacked up PostgreSQL's security system, no. If they provide an unsafe default like that without giving you a way to change it, choose another service provider.

Collectives™ on Stack Overflow

Postgres: prevent new user from creating tables, without superuser

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related