Postgres Pro
Downloads
Home   >   mailing lists

Grant question - Mailing list pgsql-general

From Michael Black
Subject Grant question
Date
Msg-id BLU144-W126A1B3E408091EF0ECC3FFAC00@phx.gbl
Whole thread Raw
In response to Re: Index question  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Grant question  (Bill Moran <wmoran@potentialtech.com>)
Re: Grant question  (S G <sgennaria2@gmail.com>)
Re: Grant question  (Bosco Rama <postgres@boscorama.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: how are you?
Next
From: Michael Black
Date:
Subject: Re: Index question