Re: I can't drop a user if I don't drop his grants beforehand?????????????????? - Mailing list pgsql-general

From Nico Sabbi
Subject Re: I can't drop a user if I don't drop his grants beforehand??????????????????
Date
Msg-id 4A1FC366.1050405@officinedigitali.it
Whole thread Raw
In response to Re: I can't drop a user if I don't drop his grants beforehand??????????????????  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: I can't drop a user if I don't drop his grants beforehand??????????????????
List 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 by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Converting each item in array to a query result row
Next
From: Thomas Pundt
Date:
Subject: Re: Please remove me from the list!