Postgres Pro
Downloads
Home   >   mailing lists

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

From Niklas Johansson
Subject Re: Created non-owner user cannot see database
Date
Msg-id 37B225F2-A340-4F84-8490-6B8609D66E4B@codecraft.se
Whole thread Raw
In response to Created non-owner user cannot see database  ("Daniel J. Summers" <daniel@djs-consulting.com>)
Responses Re: Created non-owner user cannot see database
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Daniel J. Summers"
Date:
Subject: Created non-owner user cannot see database
Next
From: "Daniel J. Summers"
Date:
Subject: Re: Created non-owner user cannot see database