Re: [SQL] create role

2010-12-31 Thread Adrian Klaver
On Friday 31 December 2010 8:22:23 am tcapobia...@prospectiv.com wrote: > > On 31 December 2010 05:14, Tony Capobianco > > > > wrote: > >> esave_dw=> \d members > >> Did not find any relation named "members". > >> esave_dw=> > >> esave_dw=> \d esave.members > >>                     Table "esave.me

Re: [SQL] create role

2010-12-31 Thread Adrian Klaver
On Friday 31 December 2010 8:22:23 am tcapobia...@prospectiv.com wrote: > > On 31 December 2010 05:14, Tony Capobianco > > > > wrote: > >> esave_dw=> \d members > >> Did not find any relation named "members". > >> esave_dw=> > >> esave_dw=> \d esave.members > >>                     Table "esave.me

Re: [SQL] create role

2010-12-31 Thread tcapobianco
> On 31 December 2010 05:14, Tony Capobianco > wrote: >> esave_dw=> \d members >> Did not find any relation named "members". >> esave_dw=> >> esave_dw=> \d esave.members >>                     Table "esave.members" >>       Column        |            Type             | Modifiers >> ---

Re: [SQL] create role

2010-12-30 Thread Adrian Klaver
On Thursday 30 December 2010 2:14:23 pm Tony Capobianco wrote: > Hi, > I'm successfully executing the below: > > create role developer login; > alter role developer set default_tablespace=dev; > alter role developer set search_path=dev,staging, esave, support, email, > public; > > grant select on m

[SQL] create role

2010-12-30 Thread Tony Capobianco
Hi, I'm successfully executing the below: create role developer login; alter role developer set default_tablespace=dev; alter role developer set search_path=dev,staging, esave, support, email, public; grant select on members to developer; grant create on schema dev to developer; However, when I