Re: Grant question

In response to Michael Black <michaelblack75052(at)hotmail(dot)com>:
>
> Ok. What am I missing here? B_USER is a defined Group Role
>
>
> CREATE ROLE "B_USER"
>
> NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;
>
>
> GRANT SELECT PRIVILEGES
>
> ON b.config_itm
>
> TO ROLE B_USER;
>
> Nets this ---------------------------------------
>
> ERROR: syntax error at or near "B_USER"
>
> LINE 3: TO ROLE B_USER;
>
> ^
>
>
>
> ********** Error **********
>
>
>
> ERROR: syntax error at or near "B_USER"
>
> SQL state: 42601
>
> Character: 42

You're missing case folding. B_USER != b_user, and when you don't put
quotes around it, the case is folded to lower case.

My personal experience advises against using case-sensitive anything in
an SQL database, but if you're going to do it, you have to do it
consistently.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/