> > How can i drop a user as SUPERUSER (!) with all privileges? > > You have to revoke the permissions that you granted. > > There are two options: > > db115150=# DROP OWNED BY ak02; > DROP OWNED > > or > > db115150=# REVOKE ALL ON SCHEMA public FROM ak02; > REVOKE > > Then you can drop the user. > > Yours, > Laurenz Albe
nice idea, but unfortunately no: db115150=# drop owned by ak02; DROP OWNED db115150=# drop user ak02; FEHLER: kann Rolle »ak02« nicht löschen, weil andere Objekte davon abhängen DETAIL: Privilegien für Schema public Andreas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
