automatical grant - role membership - Mailing list pgsql-admin

From Petr Suk
Subject automatical grant - role membership
Date
Msg-id CA+yMuNq+unyKgCrpfmmb2WK0=toMzqrx7491n=upM8Rrj3KtwQ@mail.gmail.com
Whole thread Raw
Responses Re: automatical grant - role membership  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: REVOKE command not working as expected
Next
From: Luca Ferrari
Date:
Subject: Re: automatical grant - role membership