Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group