Message-ID: <51151E5F.70906@gmail.com>
Date: Fri, 08 Feb 2013 07:48:47 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:17.0) Gecko/20130107 Thunderbird/17.0.2
MIME-Version: 1.0
To: Andreas Kretschmer <andreas@a-kretschmer.de>
CC: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: Bug, Feature, or what else?
References: 
 <119745304.24731.1360333559327.JavaMail.open-xchange@ox.ims-firmen.de>
	<51151128.8040807@gmail.com>
	<1568445490.24920.1360335539088.JavaMail.open-xchange@ox.ims-firmen.de>
	<51151764.4090405@gmail.com>
	<609013460.25018.1360337038276.JavaMail.open-xchange@ox.ims-firmen.de>
	<51151BDA.2090101@gmail.com>
	<1000342202.25103.1360338334505.JavaMail.open-xchange@ox.ims-firmen.de>
In-Reply-To: 
 <1000342202.25103.1360338334505.JavaMail.open-xchange@ox.ims-firmen.de>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

On 02/08/2013 07:45 AM, Andreas Kretschmer wrote:
>
>>
>> If I am following the Notes section correctly in:
>>
>> http://www.postgresql.org/docs/9.1/interactive/sql-revoke.html
>>
>> "If a superuser chooses to issue a GRANT or REVOKE command, the command
>> is performed as though it were issued by the owner of the affected
>> object. Since all privileges ultimately come from the object owner
>> (possibly indirectly via chains of grant options), it is possible for a
>> superuser to revoke all privileges, but this might require use of
>> CASCADE as stated above."
>>
>>
>> Try:
>>
>> revoke all on schema public from ak02 cascade;
>
> Yeah, i read that before, but doesn't help:
>
>
>
> db115150=# revoke all on schema public from ak02 cascade;
> REVOKE
> db115150=# drop user ak02;
> FEHLER:  kann Rolle »ak02« nicht löschen, weil andere Objekte davon abhängen
> DETAIL:  Privilegien für Schema public
>
>
> Strange, isn't it?

Well I got left is:

REVOKE PUBLIC FROM ak02;

>
>
> Andreas
>
>


-- 
Adrian Klaver
adrian.klaver@gmail.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general