Re: [GENERAL] Postgresql Developer Privileges

2012-08-03 Thread Jasen Betts
On 2012-07-27, John R Pierce wrote: > On 07/27/12 12:30 PM, hartrc wrote: > and make each developer a member of this role. > >> Developers do not own the objects themselves > > thats a little more tricky, as AFAIK only a 'superuser' can change the > role that owns an object, by default its owned

Re: [GENERAL] Postgresql Developer Privileges

2012-07-27 Thread John R Pierce
On 07/27/12 12:30 PM, hartrc wrote: In my agency we have application developers who do most of the database design/development themselves (not my choice) in the development environment but do not administer the database. Therefore I want developers to be able to create & drop tables, create & dro

[GENERAL] Postgresql Developer Privileges

2012-07-27 Thread hartrc
Postgresql v9.1.4 SUSE Linux Enterprise Server SP2 In my agency we have application developers who do most of the database design/development themselves (not my choice) in the development environment but do not administer the database. Therefore I want developers to be able to create & drop tables