Re: [SQL] create role

2010-12-31 Thread tcapobianco
On 31 December 2010 05:14, Tony Capobianco tcapobia...@prospectiv.com 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-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 tcapobia...@prospectiv.com wrote: esave_dw= \d members Did not find any relation named members. esave_dw= esave_dw= \d esave.members                     Table

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 tcapobia...@prospectiv.com wrote: esave_dw= \d members Did not find any relation named members. esave_dw= esave_dw= \d esave.members                     Table

[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

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 members