Re: Grant question

From: Bosco Rama <postgres(at)boscorama(dot)com>
To: Michael Black <michaelblack75052(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Grant question
Date: 2011-03-02 19:39:20
Message-ID: 4D6E9CE8.1000503@boscorama.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Black wrote:
>
> Ok. What am I missing here? B_USER is a defined Group Role
>
> CREATE ROLE "B_USER"

You used double-quotes here. This will preserve case and any
non-standard identifier characters (spaces, punctuation, etc.)

> TO ROLE B_USER;

And, thus, you need to use them here. Without the double-quotes
PG assumes lowercase.

HTH

Bosco.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James B. Byrne 2011-03-02 20:11:30 How to approach dynamic status reporting
Previous Message S G 2011-03-02 19:36:51 Re: Grant question