Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A38AC632EB2 for ; Tue, 24 Aug 2010 10:35:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 18134-04 for ; Tue, 24 Aug 2010 13:35:12 +0000 (UTC) X-Greylist: delayed 00:09:29.975234 by SQLgrey-1.7.6 Received: from maillnx-us312.fmr.com (maillnx-us312.fmr.com [192.223.178.27]) by mail.postgresql.org (Postfix) with ESMTP id 9CB83633248 for ; Tue, 24 Aug 2010 10:35:05 -0300 (ADT) X-filenames: None Received: from msgmrosm01win.dmn1.fmr.com ([172.26.7.127]) by maillnx-us312.fmr.com with SMTP; 24 Aug 2010 09:25:33 -0400 Received: from msgrtpiv03vwin.FMR.COM (10.93.69.194) by MSGMROSM01WIN.dmn1.fmr.com (Sigaba Gateway v4.1) with ESMTP id 336404384; Tue, 24 Aug 2010 09:25:33 -0400 X-TM-IMSS-Message-ID: <01eb0c8e0000879f@msgrtpiv03vwin.fmr.com> Received: from MSGMMKIM01WIN.DMN1.FMR.COM ([172.25.108.46]) by msgrtpiv03vwin.fmr.com ([10.93.69.194]) with ESMTP (TREND IMSS SMTP Service 7.0) id 01eb0c8e0000879f ; Tue, 24 Aug 2010 09:25:32 -0400 Received: from msgbosclm2win.DMN1.FMR.COM ([10.46.17.17]) by MSGMMKIM01WIN.DMN1.FMR.COM with Microsoft SMTPSVC(5.0.2195.7381); Tue, 24 Aug 2010 09:25:31 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: Unable to drop role Date: Tue, 24 Aug 2010 09:25:30 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Unable to drop role Thread-Index: ActDIN/UN6LUQxraStyWFzQH2DUUeAAbkrYg References: <16094.1282608675@sss.pgh.pa.us> From: "McGehee, Robert" To: "Tom Lane" , "Alvaro Herrera" Cc: X-OriginalArrivalTime: 24 Aug 2010 13:25:31.0055 (UTC) FILETIME=[D30EFBF0:01CB438F] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.2 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201008/176 X-Sequence-Number: 35425 Thanks Tom and Alvaro for clearing up my confusion. \l showed that a485099 had both (C)reate and (T)emporary access. Revoking those allowed me to drop the role. Thanks for the help! -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 Sent: Monday, August 23, 2010 8:11 PM To: McGehee, Robert Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Unable to drop role=20 "McGehee, Robert" writes: > template1=3D# DROP ROLE a485099; > ERROR: role "a485099" cannot be dropped because some objects depend on it > DETAIL: access to database template1 > template1=3D# REVOKE CONNECT ON DATABASE template1 FROM a485099; > REVOKE CONNECT is not the only possible privilege. Try REVOKE ALL. regards, tom lane