Re: Grant question - Mailing list pgsql-general

From Bosco Rama
Subject Re: Grant question
Date
Msg-id 4D6E9CE8.1000503@boscorama.com
Whole thread Raw
In response to Grant question  (Michael Black <michaelblack75052@hotmail.com>)
List 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.


pgsql-general by date:

Previous
From: S G
Date:
Subject: Re: Grant question
Next
From: "James B. Byrne"
Date:
Subject: How to approach dynamic status reporting