Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 53D74632BDA for ; Tue, 7 Jul 2009 07:48:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 67807-04-2 for ; Tue, 7 Jul 2009 07:48:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136029.authsmtp.com (outmail136029.authsmtp.com [62.13.136.29]) by mail.postgresql.org (Postfix) with ESMTP id 5A74F633B2F for ; Tue, 7 Jul 2009 07:45:46 -0300 (ADT) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n67Ajiip063447; Tue, 7 Jul 2009 11:45:44 +0100 (BST) Received: from [192.168.0.3] (88-111-6-11.dynamic.dsl.as9105.com [88.111.6.11]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id n67AjgWb065189; Tue, 7 Jul 2009 11:45:43 +0100 (BST) Subject: Re: GRANT ON ALL IN schema From: Simon Riggs To: Petr Jelinek Cc: PostgreSQL-development In-Reply-To: <4A4DE104.8090605@pjmodos.net> References: <4A37BF63.50008@pjmodos.net> <4A37E122.8070303@pjmodos.net> <4A38A956.8080600@pjmodos.net> <4A4DE104.8090605@pjmodos.net> Content-Type: text/plain Date: Tue, 07 Jul 2009 11:45:14 +0100 Message-Id: <1246963514.3874.156.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 5200f914-6ae3-11de-98d8-002264978518 X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFaAJbZ0xd HGQLW11EUVx7XWZ/ bwkfZQ1DY0tPQQN0 UUlWQFdQERpoT0IH AW9EBX4gdwNDeXZ5 K0dhXnYVWUZ6dRB0 Q0pJEzxTZnphaTRK TUlQIwtJcANIfBlB Y1d3UXIFLwdSbGoL PyYYHB0LBgAXBx58 ZD1FCnRaaGIvVh8a DwsJHTgqFCVf X-Authentic-SMTP: 61633235383639.pelican.dmpriest.net.uk:1562/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL=0.008 X-Spam-Level: X-Archive-Number: 200907/374 X-Sequence-Number: 140996 On Fri, 2009-07-03 at 12:44 +0200, Petr Jelinek wrote: > Petr Jelinek wrote: > > So, here is the first version of the patch. > Attached is v2 with slightly improved code, nothing has changed > feature-wise. I would like to see GRANT ... ON ALL OBJECTS ... because I know that I will forget to do TABLES, VIEWS and SEQUENCES every time I want to do this. If we are aggregating all objects of a type, why not aggregate all objects, so we just issue one command? (I'm sure we can do something intelligent with privileges that don't apply to all object types rather than just fail. e.g. UPDATE privilege should be same as USAGE on a sequence.) -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support