Re: revoke create table from a user - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: revoke create table from a user
Date
Msg-id 20031108221350.GB26691@wolff.to
Whole thread Raw
In response to revoke create table from a user  ("bagley@traderonline.com" <bagley@traderonline.com>)
Responses Re: revoke create table from a user  ("bagley@traderonline.com" <bagley@traderonline.com>)
List pgsql-admin
On Fri, Nov 07, 2003 at 15:47:50 -0500,
  "bagley@traderonline.com" <bagley@traderonline.com> wrote:
> I am trying to revoke the create table privilege from a user in a
> database.
>
> I have revoked create on database and on the public schema, yet I can
> still create table as that user.  what else do I need to do?

Is that user a superuser? If you gave that user the ability to create
new users then they are a superuser and access controls don't apply
to them.

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Volunteers Needed
Next
From: Bruce Momjian
Date:
Subject: Re: About Postgres Db size