Re: Bug, Feature, or what else? - Mailing list pgsql-general

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