I did some more testing and the result is that ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT ALL ON TABLES mygroup; works fine. The only thing I had to do is to run this SQL at first when logged as 'role1' and then again as 'role2'. Previously I run it as 'postgres' role and that is why it was not working.
On Wed, Nov 13, 2013 at 4:26 PM, Petr Suk <petrxsuk@gmail.com> wrote: > Hi, > I am trying to avoid neediness of manual settings of privileges for new > tables and views for roles in the same membership. > Let's say I have one DB schema (myschema) and two DB users (roles: role1, > role2). "Role1" and "role2" are in mebership of role "mygroup". > I want my DB to work like this: > "role1" create some table in "myschema" and is the owner of this table. I > want "role2" to automatically have all privileges on this table.