Re: automatical grant - role membership - Mailing list pgsql-admin

From Petr Suk
Subject Re: automatical grant - role membership
Date
Msg-id CA+yMuNqxZu+xZeGiD-fdC+QZK-x9+zg03X8xzDpBvQcVTncYxg@mail.gmail.com
Whole thread Raw
In response to Re: automatical grant - role membership  (Luca Ferrari <fluca1978@infinito.it>)
Responses Re: checking if sequence exists
List pgsql-admin
Thanks Luca.
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.

Thanks again.

Petr


2013/11/14 Luca Ferrari <fluca1978@infinito.it>
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.

Making role2 inheriting from role1?

Luca

pgsql-admin by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: automatical grant - role membership
Next
From: Karl Hafner
Date:
Subject: