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-29 14:50:37
Message-ID: 20090529145037.GA10092@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nico Sabbi wrote:
> Alvaro Herrera ha scritto:

>>> 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?

> No, I didn't because the tables weren't owned by the user I wanted to
> drop, but by another one.

DROP OWNED drops GRANTs too.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2009-05-29 14:52:06 Re: pg_usleep() location
Previous Message Tom Lane 2009-05-29 14:44:57 Re: Converting each item in array to a query result row