On Wed, Mar 2, 2011 at 2:30 PM, Michael Black <michaelblack75...@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;" -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
