Re: Bug, Feature, or what else?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Bug, Feature, or what else?
Date: 2013-02-08 17:01:44
Message-ID: 51152F78.8040506@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On 02/08/2013 07:57 AM, Andreas Kretschmer wrote:

>> Well I got left is:
>>
>> REVOKE PUBLIC FROM ak02;
>>
>
> i think you mean:
>
> db115150=# revoke all on schema public from ak02;
> REVOKE
> db115150=# drop user ak02;
> FEHLER: kann Rolle »ak02« nicht löschen, weil andere Objekte davon abhängen
> DETAIL: Privilegien für Schema public
>

No I was trying to revoke membership in the PUBLIC role for ak02, on the
chance that ak02 was picking up privileges from it. I do not know if
that is even possible, but at this point I am grasping at straws.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-02-08 17:09:29 DROP OWNED BY fails to drop privileges granted by non-owners (was Re: [GENERAL] Bug, Feature, or what else?)
Previous Message Adrian Klaver 2013-02-08 16:39:04 Re: Bug, Feature, or what else?

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Janes 2013-02-08 17:01:52 Re: Too frequent checkpoints ?
Previous Message Fujii Masao 2013-02-08 16:55:30 Re: Too frequent checkpoints ?