Re: [GENERAL] ALTER DEFAULT PRIVILEGES target_role doesn't work with group roles

2012-02-22 Thread Albe Laurenz
Keith Fiske wrote: > Situation: > I have two roles, alice & bob. Both are members of the dev_user group role. > I have a schema called 'reports' that both of these users would like > to be able to manage. > > I thought I could use the ALTER DEFAULT PRIVILEGES option > (http://www.postgresql.org/do

[GENERAL] ALTER DEFAULT PRIVILEGES target_role doesn't work with group roles

2012-02-21 Thread Keith Fiske
Situation: I have two roles, alice & bob. Both are members of the dev_user group role. I have a schema called 'reports' that both of these users would like to be able to manage. I thought I could use the ALTER DEFAULT PRIVILEGES option (http://www.postgresql.org/docs/9.1/static/sql-alterdefaultpri