Kevin Grittner wrote: > >>> raf <r...@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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
