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

From: Nico Sabbi <nsabbi(at)officinedigitali(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: I can't drop a user if I don't drop his grants beforehand??????????????????
Date: 2009-05-29 11:13:42
Message-ID: 4A1FC366.1050405@officinedigitali.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Pundt 2009-05-29 11:22:38 Re: Please remove me from the list!
Previous Message Grzegorz Jaśkiewicz 2009-05-29 10:55:08 Re: Converting each item in array to a query result row