Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 51EFB64FCF4 for ; Sun, 20 Jul 2008 11:09:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 01437-05 for ; Sun, 20 Jul 2008 11:09:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sabrina.lunarpages.com (sabrina.lunarpages.com [74.50.7.15]) by postgresql.org (Postfix) with ESMTP id 5352264FCF0 for ; Sun, 20 Jul 2008 11:09:30 -0300 (ADT) Received: from c-69-252-223-143.hsd1.nm.comcast.net ([69.252.223.143] helo=[192.168.0.101]) by sabrina.lunarpages.com with esmtpa (Exim 4.68) (envelope-from ) id 1KKZbM-0001jD-OT for pgsql-admin@postgresql.org; Sun, 20 Jul 2008 07:09:28 -0700 Message-ID: <48834705.7090502@djs-consulting.com> Date: Sun, 20 Jul 2008 08:09:09 -0600 From: "Daniel J. Summers" Organization: DJS Consulting User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Created non-owner user cannot see database References: <4882A742.4060500@djs-consulting.com> <37B225F2-A340-4F84-8490-6B8609D66E4B@codecraft.se> In-Reply-To: <37B225F2-A340-4F84-8490-6B8609D66E4B@codecraft.se> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - sabrina.lunarpages.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - djs-consulting.com X-Source: X-Source-Args: X-Source-Dir: 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: 200807/176 X-Sequence-Number: 29786 Niklas Johansson wrote: > > On 20 jul 2008, at 04.47, Daniel J. Summers wrote: >> grant usage on database custom_database to user_no_2; >> >> Now, none of these commands failed - they all came back with "CREATE >> ROLE" (or the appropriate response). > > Are you sure? > > 'GRANT USAGE ON DATABASE...' is invalid syntax. You probably want > 'GRANT CONNECT ON DATABASE...'. Ah - it had been a while since I originally set it up. I just tried "GRANT CONNECT", and the problem still exists. Thanks for the suggestion. :) -- Daniel J. Summers Owner, DJS Consulting E-mail - daniel@djs-consulting.com Website - http://www.djs-consulting.com Technology Blog - http://www.djs-consulting.com/linux/blog GEEKCODE 3.12 GCS/IT d s-:+ a C++ L++ E--- W++ N++ o? K- w !O M-- V PS+ PE++ Y? !PGP t+ 5? X+ R* tv b+ DI++ D+ G- e h---- r+++ y++++