Обсуждение: roles and inheritance

Поиск
Список
Период
Сортировка

roles and inheritance

От
Carol Walter
Дата:
Greetings,

I'm creating roles for the first time in Postgres.  Up until now,
I've only needed to grant privs to individuals.  I've been going over
the documentation on this and there is a part that is not very clear
to me.  It concerns inheritance.  First of all, if I create the role
database_name_select and add John and Mary to it, the role
database_name_select won't inherit John and Mary's privs, will it?  I
do want John and Mary to inherit the privs of the
database_name_select role.  Do I set database_name_select with the
option inherit or no inherit?  The implication is that roles can
inherit from other roles; is that correct?

Thanks for your help,

Carol

Re: roles and inheritance

От
Julius Tuskenis
Дата:
Hi, Carol.

ALTER Role John
  INHERIT;

this will make the role John inherit permitions from the permition role
group they are in.



Carol Walter rašė:
> Greetings,
>
> I'm creating roles for the first time in Postgres.  Up until now, I've
> only needed to grant privs to individuals.  I've been going over the
> documentation on this and there is a part that is not very clear to
> me.  It concerns inheritance.  First of all, if I create the role
> database_name_select and add John and Mary to it, the role
> database_name_select won't inherit John and Mary's privs, will it?  I
> do want John and Mary to inherit the privs of the database_name_select
> role.  Do I set database_name_select with the option inherit or no
> inherit?  The implication is that roles can inherit from other roles;
> is that correct?
>
> Thanks for your help,
>
> Carol
>


--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050