Grant question
От
Michael Black
Тема
Grant question
Дата
Msg-id
BLU144-W126A1B3E408091EF0ECC3FFAC00@phx.gbl
Ответ на
Re: Index question (Joshua D. Drake)
Список
Дерево обсуждения
pg_dump slow with bytea data "chris r." <chricki@gmx.net>
Re: pg_dump slow with bytea data "chris r." <chricki@gmx.net>
Re: pg_dump slow with bytea data Merlin Moncure <mmoncure@gmail.com>
Re: pg_dump slow with bytea data "chris r." <chricki@gmx.net>
Re: pg_dump slow with bytea data Merlin Moncure <mmoncure@gmail.com>
Re: pg_dump slow with bytea data Merlin Moncure <mmoncure@gmail.com>
Re: pg_dump slow with bytea data Alban Hertroys <dalroi@solfertje.student.utwente.nl>
Index question Michael Black <michaelblack75052@hotmail.com>
Re: Index question Andrew Sullivan <ajs@crankycanuck.ca>
Re: Index question "Joshua D. Drake" <jd@commandprompt.com>
Grant question Michael Black <michaelblack75052@hotmail.com>
Re: Grant question Bill Moran <wmoran@potentialtech.com>
Re: Grant question Bosco Rama <postgres@boscorama.com>
Re: Grant question S G <sgennaria2@gmail.com>
Re: Index question Michael Black <michaelblack75052@hotmail.com>
Re: *****SPAM***** Index question Scott Ribe <scott_ribe@elevated-dev.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
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
В списке pgsql-general по дате отправления
