Re: Created non-owner user cannot see database

From: Niklas Johansson <pgmailings(at)codecraft(dot)se>
To: "Daniel J(dot) Summers" <daniel(at)djs-consulting(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Created non-owner user cannot see database
Date: 2008-07-20 12:50:26
Message-ID: 37B225F2-A340-4F84-8490-6B8609D66E4B@codecraft.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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...'.

Sincerely,

Niklas Johansson

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel J. Summers 2008-07-20 14:09:09 Re: Created non-owner user cannot see database
Previous Message Niklas Johansson 2008-07-20 12:16:54 Re: Created non-owner user cannot see database