Postgres Pro
Downloads
Home   >   mailing lists

Re: Created non-owner user cannot see database - Mailing list pgsql-admin

From Daniel J. Summers
Subject Re: Created non-owner user cannot see database
Date
Msg-id 48834705.7090502@djs-consulting.com
Whole thread Raw
In response to Re: Created non-owner user cannot see database  (Niklas Johansson <pgmailings@codecraft.se>)
Responses Re: Created non-owner user cannot see database  (Niklas Johansson <pgmailings@codecraft.se>)
List pgsql-admin
Tree view 
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 <mailto:daniel@djs-consulting.com>
Website -      http://www.djs-consulting.com <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++++

pgsql-admin by date:

Previous
From: Niklas Johansson
Date:
Subject: Re: Created non-owner user cannot see database
Next
From: Niklas Johansson
Date:
Subject: Re: Created non-owner user cannot see database