Re: automatical grant - role membership

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: automatical grant - role membership
Дата
Msg-id CAKoxK+5DvJYF3tor6=kJKdfhpxoui6PAFjuhy9WzHjZbngGDPQ@mail.gmail.com
обсуждение исходный текст
Ответ на automatical grant - role membership  (Petr Suk <petrxsuk@gmail.com>)
Ответы Re: automatical grant - role membership  (Petr Suk <petrxsuk@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Petr Suk
Дата:
Сообщение: automatical grant - role membership
Следующее
От: Petr Suk
Дата:
Сообщение: Re: automatical grant - role membership