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 1941FA53-07B1-4984-AC21-CF0628446D39@codecraft.se
Whole thread Raw
In response to Created non-owner user cannot see database  ("Daniel J. Summers" <daniel@djs-consulting.com>)
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: Alvaro Herrera
Date:
Subject: Re: auto vacuum for opentaps
Next
From: "Rajesh Kumar Mallah"
Date:
Subject: conditional logging based on client