Re: REVOKE question

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Bohdan Linda <bohdan(dot)linda(at)seznam(dot)cz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: REVOKE question
Date: 2005-09-02 15:56:48
Message-ID: 20050902155648.GA28022@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 02, 2005 at 05:31:54PM +0200, Bohdan Linda wrote:

> Hello,
>
> I have encountered on (for me) wierd thing. When dropping an user, the
> database will not forget his permissions. After his recreation he has the
> original permissions.

Known problem, partially fixed in 8.1. (At least it won't allow you to
drop the user if it owns something, or is mentioned in an ACL.)

--
Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com
"Some men are heterosexual, and some are bisexual, and some
men don't think about sex at all... they become lawyers" (Woody Allen)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-09-02 16:41:24 Re: PL/pgSQL: EXCEPTION NOSAVEPOINT
Previous Message Bohdan Linda 2005-09-02 15:31:54 REVOKE question