In response to Michael Black <michaelblack75052@xxxxxxxxxxx>: > > 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
