Re: How to prevent users from creating tables

Kevin Grittner wrote:

> >>> 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

i wasn't logged in as the superuser.
thanks. it's good now.

cheers,
raf