Re: revoke create table from a user

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "bagley(at)traderonline(dot)com" <bagley(at)traderonline(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: revoke create table from a user
Date: 2003-11-08 22:13:50
Message-ID: 20031108221350.GB26691@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Nov 07, 2003 at 15:47:50 -0500,
"bagley(at)traderonline(dot)com" <bagley(at)traderonline(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Christopher Browne 2003-11-09 00:02:23 Re: performance problem - 10.000 databases
Previous Message Tom Lane 2003-11-08 21:03:53 Re: Volunteers Needed