Re: grant/revoke for alter/drop?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andy Kriger <akriger(at)greaterthanone(dot)com>
Cc: Pgsql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: grant/revoke for alter/drop?
Date: 2002-09-24 15:04:38
Message-ID: 20020924150438.GA15530@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 24, 2002 at 10:49:22 -0400,
Andy Kriger <akriger(at)greaterthanone(dot)com> wrote:
> Does Postgres allow you to revoke privilages for ALTER, CREATE, and DROP
> commands? If not, how can you enforce a read/write table that cannot be
> removed by a user and who's structure cannot be changed?

Only the creator or a superuser can drop an object.
In 7.2 you can't control who creates objects. In 7.3 you will be able to
do this using schemas.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yury Bokhoncovich 2002-09-24 15:05:06 Re: rotatelog / logrotate with PostgreSQL
Previous Message Roland Roberts 2002-09-24 14:55:41 Re: [SQL] CURRENT_TIMESTAMP