"McGehee, Robert" <Robert.McGehee@xxxxxxxxxxxxxxxx> writes: > template1=# DROP ROLE a485099; > ERROR: role "a485099" cannot be dropped because some objects depend on it > DETAIL: access to database template1 > template1=# REVOKE CONNECT ON DATABASE template1 FROM a485099; > REVOKE CONNECT is not the only possible privilege. Try REVOKE ALL. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
