Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 01088633180 for ; Tue, 24 Aug 2010 10:36:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 27074-06 for ; Tue, 24 Aug 2010 13:36:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 07C2963311F for ; Tue, 24 Aug 2010 10:36:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o7ODa6Xb027617; Tue, 24 Aug 2010 09:36:06 -0400 (EDT) To: "McGehee, Robert" cc: "Alvaro Herrera" , pgsql-admin@postgresql.org Subject: Re: Unable to drop role In-reply-to: References: <16094.1282608675@sss.pgh.pa.us> Comments: In-reply-to "McGehee, Robert" message dated "Tue, 24 Aug 2010 09:25:30 -0400" Date: Tue, 24 Aug 2010 09:36:05 -0400 Message-ID: <27616.1282656965@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/173 X-Sequence-Number: 35422 "McGehee, Robert" writes: > 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! I wonder whether Robert's confusion doesn't stem from a poor choice of message wording: >> template1=# DROP ROLE a485099; >> ERROR: role "a485099" cannot be dropped because some objects depend on it >> DETAIL: access to database template1 I can see how "access to" might be read as specifically meaning "CONNECT privilege for". Should we change this message from "access to whatever" to "privileges for whatever", or some such wording? regards, tom lane