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.
I was trying to use ALTER DEFAULT PRIVILEGES, but I still don't have what I need.
#
ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT ALL ON TABLES TO mygroup;
#
Please, am I missing something? I am using PostgreSQL 9.1
Thanks a lot.
Petr