Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 5A28E634617 for ; Wed, 17 Jun 2009 13:52:53 -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 03652-02 for ; Wed, 17 Jun 2009 13:52:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from phoenix.advel.cz (phoenix.advel.cz [81.0.239.26]) by mail.postgresql.org (Postfix) with SMTP id 12744633ED4 for ; Wed, 17 Jun 2009 13:52:49 -0300 (ADT) Received: (qmail 13768 invoked from network); 17 Jun 2009 18:54:12 +0200 Received: from unknown (HELO ?10.12.0.96?) (88.103.48.48) by 192.168.1.50 with SMTP; 17 Jun 2009 18:54:12 +0200 Message-ID: <4A391F55.5060005@pjmodos.net> Date: Wed, 17 Jun 2009 18:52:37 +0200 From: Petr Jelinek User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: Greg Stark CC: Guillaume Smet , Tom Lane , Peter Eisentraut , pgsql-hackers@postgresql.org Subject: Re: GRANT ON ALL IN schema References: <4A37BF63.50008@pjmodos.net> <200906171644.53717.peter_e@gmx.net> <25515.1245248104@sss.pgh.pa.us> <200906171744.24456.peter_e@gmx.net> <26370.1245250052@sss.pgh.pa.us> <4A3904CC.1020105@pjmodos.net> <1d4e0c10906170925o5001f808j8e4e49b5c620c788@mail.gmail.com> <00E32148-189B-45CA-ADA9-2454AEBE50B5@enterprisedb.com> In-Reply-To: <00E32148-189B-45CA-ADA9-2454AEBE50B5@enterprisedb.com> 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.635 tagged_above=0 required=5 tests=AWL=0.635 X-Spam-Level: X-Archive-Number: 200906/1073 X-Sequence-Number: 140128 Greg Stark wrote: > Isn't the answer to grant permissions to a role and then just put > people in that role? > Still have to give permissions at least to that role. -- Regards Petr Jelinek (PJMODOS)