> > 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=# begin; BEGIN 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 db115150=# -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
