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