Re: grant/revoke for alter/drop?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: grant/revoke for alter/drop?
Дата
Msg-id 20020924150438.GA15530@wolff.to
обсуждение исходный текст
Ответ на grant/revoke for alter/drop?  ("Andy Kriger" <akriger@greaterthanone.com>)
Список 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 по дате отправления: