Re: How to prevent users from creating tables - Mailing list pgsql-admin

>>> raf <raf@raf.org> wrote:
>   revoke all privileges on schema public from public;
>   revoke all privileges on schema public from staff; -- staff is a
role
>
> then i get two warnings:
>
>   WARNING:  no privileges could be revoked for "public"
>   WARNING:  no privileges could be revoked for "public"
>
> and a member of the staff role can still create tables.
> if i replace "all privileges" with just "create", i
> get the same warnings and still no effect.

Are you logged in as a database superuser?

(Database owner is not good enough for this operation.)

-Kevin