Re: grant/revoke for alter/drop? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: grant/revoke for alter/drop?
Date
Msg-id 20020924150438.GA15530@wolff.to
Whole thread Raw
In response to grant/revoke for alter/drop?  ("Andy Kriger" <akriger@greaterthanone.com>)
List pgsql-general
On Tue, Sep 24, 2002 at 10:49:22 -0400,
  Andy Kriger <akriger@greaterthanone.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.

pgsql-general by date:

Previous
From: Roland Roberts
Date:
Subject: Re: [SQL] CURRENT_TIMESTAMP
Next
From: Yury Bokhoncovich
Date:
Subject: Re: rotatelog / logrotate with PostgreSQL