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

Re: Created non-owner user cannot see database

From: Niklas Johansson <niklas(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:16:54
Message-ID: 1941FA53-07B1-4984-AC21-CF0628446D39@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

pgsql-admin by date

Next:From: Niklas JohanssonDate: 2008-07-20 12:50:26
Subject: Re: Created non-owner user cannot see database
Previous:From: Daniel J. SummersDate: 2008-07-20 02:47:30
Subject: Created non-owner user cannot see database

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