Grant question

From: Michael Black <michaelblack75052(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Grant question
Date: 2011-03-02 19:30:19
Message-ID: BLU144-W126A1B3E408091EF0ECC3FFAC00@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Black 2011-03-02 19:30:49 Re: Index question
Previous Message John R Pierce 2011-03-02 19:11:56 Re: how are you?