"McGehee, Robert" <robert.mcge...@geodecapital.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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to