Grant question
| От | Michael Black |
|---|---|
| Тема | Grant question |
| Дата | |
| Msg-id | BLU144-W126A1B3E408091EF0ECC3FFAC00@phx.gbl обсуждение исходный текст |
| Ответ на | Re: Index question ("Joshua D. Drake" <jd@commandprompt.com>) |
| Ответы |
Re: Grant question
Re: Grant question Re: Grant question |
| Список | pgsql-general |
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 по дате отправления: