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

Поиск
Список
Период
Сортировка
От Nico Sabbi
Тема Re: I can't drop a user if I don't drop his grants beforehand??????????????????
Дата
Msg-id 4A1FC366.1050405@officinedigitali.it
обсуждение исходный текст
Ответ на Re: I can't drop a user if I don't drop his grants beforehand??????????????????  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: I can't drop a user if I don't drop his grants beforehand??????????????????  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Alvaro Herrera ha scritto:
> 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?
>
>

Hi,
sorry for the big delay.
No, I didn't because the tables weren't owned by the user I wanted to
drop, but by another one.

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

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: Converting each item in array to a query result row
Следующее
От: Thomas Pundt
Дата:
Сообщение: Re: Please remove me from the list!