grant/revoke for alter/drop?
Started by Andy Krigerover 23 years ago2 messagesgeneral
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?
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.