Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id D2557632D85 for ; Tue, 11 May 2010 20:04:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 53341-05 for ; Tue, 11 May 2010 23:04:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [69.36.227.170]) by mail.postgresql.org (Postfix) with ESMTP id ECFCD632CF2 for ; Tue, 11 May 2010 20:04:37 -0300 (ADT) Received: from dsl081-245-111.sfo1.dsl.speakeasy.net ([64.81.245.111] helo=Sidney-Stratton.local) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:CAMELLIA256-SHA:256) (Exim 4.69) (envelope-from ) id 1OByV7-0007KW-AN for pgsql-testers@postgresql.org; Tue, 11 May 2010 16:04:35 -0700 Message-ID: <4BE9E27B.7080303@agliodbs.com> Date: Tue, 11 May 2010 16:04:27 -0700 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: pgsql-testers@postgresql.org Subject: Re: testing simple SELECT commands on newly-created databases. Apparently blocked by (lack of) privileges? References: <149044522.9106971273618540977.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> In-Reply-To: <149044522.9106971273618540977.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201005/28 X-Sequence-Number: 111 On 5/11/10 3:55 PM, Lou Picciano wrote: > Josh, > > I'm beating a dead horse, I know: > > Then, what is the effect of: > GRANT ALL ON DATABASE fubar TO "Mr. Dataguy"; > GRANT ALL ON DATABASE fubar TO "Mrs. Datareader"; etc? > > Isn't the above how we've been granting wholesale access to a db? I > must be missing something. That grants CONNECT, USE and CREATE on the database to the user. It says nothing about individual objects. If you want to grant on all objects in a database, see 9.0's GRANT ON ALL feature. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com