Re: [GENERAL] Maintaining user roles and permissions in Postgres - general question

2009-06-19 Thread Richard Huxton
Scott Marlowe wrote: On Thu, Jun 18, 2009 at 8:03 PM, Postgres User wrote: Does anyone have a recommendation for maintaining user permissions on a changing database? The lack of an option to grant specific rights to all objects of a given type within a Postgres db obviously I think we're answ

Re: [GENERAL] Maintaining user roles and permissions in Postgres - general question

2009-06-18 Thread Scott Marlowe
On Thu, Jun 18, 2009 at 8:03 PM, Postgres User wrote: > Does anyone have a recommendation for maintaining user permissions on > a changing database?  The lack of an option to grant specific rights > to all objects of a given type within a Postgres db obviously places > the burden on the administrat

Re: [GENERAL] Maintaining user roles and permissions in Postgres - general question

2009-06-18 Thread John R Pierce
Postgres User wrote: Does anyone have a recommendation for maintaining user permissions on a changing database? The lack of an option to grant specific rights to all objects of a given type within a Postgres db obviously places the burden on the administrator to keep roles updated as objects are

[GENERAL] Maintaining user roles and permissions in Postgres - general question

2009-06-18 Thread Postgres User
Does anyone have a recommendation for maintaining user permissions on a changing database? The lack of an option to grant specific rights to all objects of a given type within a Postgres db obviously places the burden on the administrator to keep roles updated as objects are added and dropped from