Code
Reputation: 6251
Postgres: prevent new user from creating tables, without superuser
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.
Upvotes: 2
Views: 294
Answers (1)
Laurenz Albe
Reputation: 246483
You have to run that statement as the user who owns public.
Upvotes: 2
Related Questions
- Can a Non-Superuser create DBs for other users in Postgres 10?
- Postgres (Greenplum) disallow user role to create table as themselves
- allow create table for some users, not all
- Postgres - how can I restrict the privilege to create/drop a table?
- Restrict user privileges to one particular database only
- Restrict access to creating users on PostgreSQL
- Restrict create table privilege to newly created users in RDS PostgreSQL 9.6
- Limit db user permission on google cloud sql
- Postgres: Restrict user account/role ability to create database objects
- Postgres user create database