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

Adrian Klaver <adrian.klaver@gmail.com> hat am 8. Februar 2013 um 16:19
geschrieben:
> On 02/08/2013 06:58 AM, Andreas Kretschmer wrote:
> >
> >>> How can i drop a user as SUPERUSER (!) with all privileges?
> >>
> >> I believe you will need to REVOKE ALL ON SCHEMA public FROM ak02.
> >
> >
> > doesn't help:
> >
> > -bash-4.1$ psql -U postgres db115150
> > psql (9.1.8)
> > Type "help" for help.
> >
> > db115150=3D# begin;
> > BEGIN
> > db115150=3D# revoke all on schema public from ak02;
> > REVOKE
> > db115150=3D# drop user ak02;
> > FEHLER:  kann Rolle =C2=BBak02=C2=AB nicht l=C3=B6schen, weil andere Ob=
jekte davon abh=C3=A4ngen
> > DETAIL:  Privilegien f=C3=BCr Schema public
> > db115150=3D#
> >
> >
>
> So what does \dn+ public show?

db115150=3D# \dn+ public
                             List of schemas
  Name  |  Owner   |      Access privileges      |      Description
--------+----------+-----------------------------+------------------------
 public | postgres | postgres=3DUC/postgres       +| standard public schema
        |          | akretschmer01=3DU*C*/postgres+|
        |          | ak02=3DUC/akretschmer01       |
(1 row)