From: | "Daniel J(dot) Summers" <daniel(at)djs-consulting(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Created non-owner user cannot see database |
Date: | 2008-07-20 14:09:09 |
Message-ID: | 48834705.7090502@djs-consulting.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)djs-consulting(dot)com <mailto:daniel(at)djs-consulting(dot)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++++
From | Date | Subject | |
---|---|---|---|
Next Message | Niklas Johansson | 2008-07-20 17:32:50 | Re: Created non-owner user cannot see database |
Previous Message | Niklas Johansson | 2008-07-20 12:50:26 | Re: Created non-owner user cannot see database |