From: | Petr Suk <petrxsuk(at)gmail(dot)com> |
---|---|
To: | Luca Ferrari <fluca1978(at)infinito(dot)it> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: automatical grant - role membership |
Date: | 2013-11-14 09:17:16 |
Message-ID: | CA+yMuNqxZu+xZeGiD-fdC+QZK-x9+zg03X8xzDpBvQcVTncYxg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)infinito(dot)it>
> On Wed, Nov 13, 2013 at 4:26 PM, Petr Suk <petrxsuk(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Karl Hafner | 2013-11-15 09:16:54 | |
Previous Message | Luca Ferrari | 2013-11-14 07:25:31 | Re: automatical grant - role membership |