Re: I can't drop a user if I don't drop his grants beforehand??????????????????

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: I can't drop a user if I don't drop his grants beforehand??????????????????
Дата
Msg-id 20090522195626.GG4466@alvh.no-ip.org
обсуждение исходный текст
Ответ на I can't drop a user if I don't drop his grants beforehand??????????????????  (Nico Sabbi <nsabbi@officinedigitali.it>)
Ответы Re: I can't drop a user if I don't drop his grants beforehand??????????????????  (Nico Sabbi <nsabbi@officinedigitali.it>)
Список pgsql-general
Nico Sabbi wrote:
> Hi,
> i can't believe my eyes. Why on earth I can't drop a user without
> previously revoking his privileges?
> This is really _crazy_ in my opinion.
>
> I'm not speaking of object ownership, but of GRANTs.

As Tom says, it's a known limitation.  Did you try REASSIGN OWNED and/or DROP
OWNED?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

В списке pgsql-general по дате отправления:

Предыдущее
От: Brandon Metcalf
Дата:
Сообщение: quoting values magic
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: question about SSIS