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