Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id AC0176347B4 for ; Wed, 17 Jun 2009 11:40:16 -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 72718-03 for ; Wed, 17 Jun 2009 11:40:05 -0300 (ADT) X-Greylist: delayed 00:08:56.417246 by SQLgrey-1.7.6 Received: from smtp-out3.iol.cz (smtp-out3.iol.cz [194.228.2.91]) by mail.postgresql.org (Postfix) with ESMTP id AE14F634617 for ; Wed, 17 Jun 2009 11:40:14 -0300 (ADT) Received: from antivir5.iol.cz (unknown [192.168.30.212]) by smtp-out3.iol.cz (Postfix) with ESMTP id 09C7ABC81FF; Wed, 17 Jun 2009 14:40:12 +0000 (UTC) Received: from localhost (antivir5.iol.cz [127.0.0.1]) by antivir5.iol.cz (Postfix) with ESMTP id ED4E02812A; Wed, 17 Jun 2009 16:40:11 +0200 (CEST) X-Virus-Scanned: amavisd-new at iol.cz Received: from antivir5.iol.cz ([127.0.0.1]) by localhost (antivir5.iol.cz [127.0.0.1]) (amavisd-new, port 10224) with LMTP id qhkcpC6Bh2-5; Wed, 17 Jun 2009 16:40:11 +0200 (CEST) Received: from port6.iol.cz (unknown [192.168.30.96]) by antivir5.iol.cz (Postfix) with ESMTP id CC6C428129; Wed, 17 Jun 2009 16:40:11 +0200 (CEST) X-SBRS: None X-SBRS-none: None X-RECVLIST: MTA-OUT-IOL X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AjACAJedOEpYZzAw/2dsb2JhbAAI1TeECAU Received: from unknown (HELO [10.12.0.96]) ([88.103.48.48]) by port6.iol.cz with ESMTP; 17 Jun 2009 16:40:11 +0200 Message-ID: <4A390043.4080405@pjmodos.net> Date: Wed, 17 Jun 2009 16:40:03 +0200 From: Petr Jelinek User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: Stephen Frost CC: Peter Eisentraut , pgsql-hackers@postgresql.org Subject: Re: GRANT ON ALL IN schema References: <4A37BF63.50008@pjmodos.net> <4A37E122.8070303@pjmodos.net> <4A38A956.8080600@pjmodos.net> <200906171644.53717.peter_e@gmx.net> <20090617140904.GL20436@tamriel.snowman.net> In-Reply-To: <20090617140904.GL20436@tamriel.snowman.net> Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200906/1054 X-Sequence-Number: 140109 Stephen Frost wrote: > I don't like the idea that a 'GRANT ALL' would actually change default > ACLs for a schema though. These are two separate and distinct things- > one is implementing a change to existing objects, the other is setting a > default for new objects. Mixing them would lead to confusion. > It doesn't. I stated that I am not implementing the second part of the TODO item in my first email specifically for this reason (the second part was GRANT ON NEW TABLES). -- Regards Petr Jelinek (PJMODOS)