Andreas Kretschmer wrote: >>> 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 >> >> So what does \dn+ public show? > > db115150=# \dn+ public > List of schemas > Name | Owner | Access privileges | Description > --------+----------+-----------------------------+------------------------ > public | postgres | postgres=UC/postgres +| standard public schema > | | akretschmer01=U*C*/postgres+| > | | ak02=UC/akretschmer01 | > (1 row)
Seems like you can't revoke privileges you didn't grant, even as superuser. Try: SET SESSION AUTHORIZATION akretschmer01; REVOKE ALL ON SCHEMA PUBLIC FROM ak02; RESET SESSION AUTHORIZATION; DROP USER ak02; Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
