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)
