Re: Grant question

On Wed, Mar 2, 2011 at 2:30 PM, Michael Black
<michaelblack75052(at)hotmail(dot)com> wrote:
> 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
>
>

Syntax in the docs seems to indicate that "TO ROLE B_USER;" should
just be "TO B_USER;"