Postgres Pro
Downloads
Home   >   mailing lists

Re: Unable to drop role - Mailing list pgsql-admin

From Tom Lane
Subject Re: Unable to drop role
Date
Msg-id 16094.1282608675@sss.pgh.pa.us
Whole thread Raw
In response to Unable to drop role  ("McGehee, Robert" <Robert.McGehee@geodecapital.com>)
List pgsql-admin
Tree view 
"McGehee, Robert" <Robert.McGehee@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

pgsql-admin by date:

Previous
From: Kieren Scott
Date:
Subject: Re: WAL and archive disks full
Next
From: Tom Lane
Date:
Subject: Re: WAL and archive disks full