Re: Created non-owner user cannot see database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Created non-owner user cannot see database
From: Niklas Johansson <niklas@xxxxxxxxxxxx>
Date: Sun, 20 Jul 2008 14:16:54 +0200
Cc: pgsql-admin@xxxxxxxxxxxxxx
In-reply-to: <4882A742.4060500@xxxxxxxxxxxxxxxxxx>
References: <4882A742.4060500@xxxxxxxxxxxxxxxxxx>


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

References:
- Created non-owner user cannot see database
  - From: Daniel J. Summers

Prev by Date: Created non-owner user cannot see database
Next by Date: Re: Created non-owner user cannot see database
Previous by thread: Created non-owner user cannot see database
Next by thread: Re: Created non-owner user cannot see database
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux