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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Nico Sabbi <nsabbi(at)officinedigitali(dot)it>
Cc: 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-22 19:56:26
Message-ID: 20090522195626.GG4466@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-05-22 20:14:38 Re: question about SSIS
Previous Message Brandon Metcalf 2009-05-22 19:54:04 quoting values magic