Thread: grant/revoke for alter/drop?

grant/revoke for alter/drop?

From
"Andy Kriger"
Date:
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?




Re: grant/revoke for alter/drop?

From
Bruno Wolff III
Date:
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.