Re: automatical grant - role membership

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Nov 13, 2013 at 4:26 PM, Petr Suk <petrxsuk@xxxxxxxxx> 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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux