X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 46CC452D44 for ; Mon, 16 May 2005 01:04:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88222-07 for ; Mon, 16 May 2005 04:04:32 +0000 (GMT) Received: from mr2.surnet.cl (smtp2.surnet.cl [216.155.73.163]) by svr1.postgresql.org (Postfix) with ESMTP id B526C5322E for ; Mon, 16 May 2005 01:04:29 -0300 (ADT) Received: from smtp2.surnet.cl (216.155.73.169) by mr2.surnet.cl (7.0.031.3) id 4259ADFA007A54A8; Mon, 16 May 2005 00:05:00 -0400 Received: from smtp1.surnet.cl (smtp1.surnet.cl []) by mr2.surnet.cl ([216.155.73.169]); Mon, 16 May 2005 04:05:00 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp1.surnet.cl (7.0.031.3) id 42587C6E00647FDA; Mon, 16 May 2005 00:03:56 -0400 Received: from localhost (200.85.219.173) by cluster.surnet.cl (7.0.024) id 4276578F001DEACD; Mon, 16 May 2005 00:04:25 -0400 Received: by localhost (Postfix, from userid 1000) id 19C4DC32DDE; Mon, 16 May 2005 00:04:32 -0400 (CLT) Date: Mon, 16 May 2005 00:04:31 -0400 From: Alvaro Herrera To: Tom Lane Cc: Hackers Subject: Re: [ADMIN] Permissions not removed when group dropped Message-ID: <20050516040431.GA9147@surnet.cl> References: <20050513213505.GB17830@surnet.cl> <172.1116038893@sss.pgh.pa.us> <20050514053053.GA26186@surnet.cl> <3868.1116084743@sss.pgh.pa.us> <20050515214253.GA8391@surnet.cl> <3358.1116193736@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3358.1116193736@sss.pgh.pa.us> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.181 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, RCVD_IN_BL_SPAMCOP_NET, RCVD_IN_NJABL_PROXY X-Spam-Level: *** X-Archive-Number: 200505/1036 X-Sequence-Number: 67912 On Sun, May 15, 2005 at 05:48:56PM -0400, Tom Lane wrote: > Alvaro Herrera writes: > > Additionally we need to think what should happen if the user is the > > grantor of some privilege. I think we should warn in RESTRICT mode, and > > in CASCADE, revoke the privilege from the grantee. > > You mean "fail in RESTRICT mode", no? Yes, with a message indicating what happened. > > Hmm. We could implement something like "DROP USER LOCALLY [CASCADE | > > RESTRICT]", which would be a very misleading name for operations 2-4 > > above. Additionally, if the user doesn't have references in other > > databases, drop the user itself. (Note it's inconsistent.) > > I'd go for something more like "DROP OWNED OBJECTS", which'd be just > the stuff internal to the current database (owned objects and ACL > entries). You don't need to drop group memberships per-database. Ok. -- Alvaro Herrera () "Find a bug in a program, and fix it, and the program will work today. Show the program how to find and fix a bug, and the program will work forever" (Oliver Silfridge)