Received: from maia.hub.org (maia-1.hub.org [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 8C727632611 for ; Sun, 2 May 2010 23:00:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 45373-02 for ; Mon, 3 May 2010 02:00:37 +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 79842632444 for ; Sun, 2 May 2010 23:00:46 -0300 (ADT) Received: from adsl-63-195-55-98.dsl.snfc21.pacbell.net ([63.195.55.98] helo=[192.168.47.103]) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:CAMELLIA256-SHA:256) (Exim 4.69) (envelope-from ) id 1O8kxc-0000hk-MG for pgsql-testers@postgresql.org; Sun, 02 May 2010 19:00:43 -0700 Message-ID: <4BDE2E41.5090505@agliodbs.com> Date: Sun, 02 May 2010 19:00:33 -0700 From: Josh Berkus User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.9pre) Gecko/20100217 Shredder/3.0.3pre MIME-Version: 1.0 To: pgsql-testers@postgresql.org Subject: Re: Trying to GRANT privileges on a newly-created database References: <1720764182.4921461272841175665.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> In-Reply-To: <1720764182.4921461272841175665.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_20=-0.001 X-Spam-Level: X-Archive-Number: 201005/3 X-Sequence-Number: 86 On 05/02/2010 03:59 PM, Lou Picciano wrote: > > > *[TEST REPORT]* > > *[Release]:* 8.5alpha2 > > *[Test Type]:* psql CLI > > *[Test]:* Trying to GRANT privileges on a newly-created database > > *[Platform]:* Solaris SPARC 4u (E450) > > *[Parameters]:* Trying to GRANT privileges on a newly-created database. > db name in lower case. > > *[Failure]: yes* > > *[Results]:* > > # CREATE DATABASE dbname; > > # GRANT ALL ON dbname TO role; > > ERROR: relatioypn "dbname" does not exist > > Please note this database is created in lower case; it has not been > renamed from upper. > > # GRANT ALL ON dbname TO role; - produces the same error. In general, to do a grant on anything other that a table you need to name the object type, i.e. GRANT ALL ON DATABASE dbname TO role; That's been true for quite a while. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com