On Wed, Mar 2, 2011 at 2:30 PM, Michael Black
<michaelblack75052@hotmail.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;"