From: raf <raf@raf.org>
To: pgsql-admin@postgresql.org
Subject: Re: How to prevent users from creating tables
Date: Thu, 5 Feb 2009 13:00:38 +1100
Message-ID: <20090205020037.GA29017@raf.org> (raw)
In-Reply-To: <49895663.EE98.0025.0@wicourts.gov>
References: <20090204005222.GA19588@raf.org>
<gmat64$unq$1@ger.gmane.org>
<20090204143740.GA25312@raf.org>
<49895663.EE98.0025.0@wicourts.gov>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: raf@raf.org
Subject: Re: How to prevent users from creating tables
In-Reply-To: <20090205020037.GA29017@raf.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox