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...'.
In response to
pgsql-admin by date
|Next:||From: Niklas Johansson||Date: 2008-07-20 12:50:26|
|Subject: Re: Created non-owner user cannot see database|
|Previous:||From: Daniel J. Summers||Date: 2008-07-20 02:47:30|
|Subject: Created non-owner user cannot see database|