X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 791D79FA4E0 for ; Fri, 7 Jul 2006 01:26:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 95093-01 for ; Fri, 7 Jul 2006 01:26:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3D8EF9F94F3 for ; Fri, 7 Jul 2006 01:26:28 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k674QS84016952; Fri, 7 Jul 2006 00:26:28 -0400 (EDT) To: Keith cc: pgsql-admin@postgresql.org Subject: Re: Roles and Superusers In-reply-to: <20060707024453.7668.qmail@web51012.mail.yahoo.com> References: <20060707024453.7668.qmail@web51012.mail.yahoo.com> Comments: In-reply-to Keith message dated "Thu, 06 Jul 2006 19:44:53 -0700" Date: Fri, 07 Jul 2006 00:26:28 -0400 Message-ID: <16951.1152246388@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/42 X-Sequence-Number: 22288 Keith writes: > It seems that the 'superuser' part of my 'leads' group > role is not functioning (code below). It appears that > the security settings are at least partially > transitive as I have one group role nested within the > other and I am able to access the appropriate > resources. The problem is that only a superuser or the > owner of a table can drop it and even though I am > supposed to be a superuser, I cannot drop the table! Then you're not a superuser ;-) I gather from your example that you are expecting superuserness to inherit through role membership. It doesn't, and neither do the other "special" privileges managed via CREATE/ALTER ROLE. It's arguable whether this is a good policy for eg. CREATEDB, but personally I think it's the right behavior for the superuser bit. When you pass out the keys to the kingdom, you want to pass 'em out one recipient at a time, eh? regards, tom lane