"McGehee, Robert" <Robert(dot)McGehee(at)geodecapital(dot)com> 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