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

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.klaver@gmail.com