pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedroles and inheritance
2+ messages / 2 participants
[nested] [flat]
* roles and inheritance
@ 2008-06-09 15:16 Carol Walter <walterc@indiana.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Carol Walter @ 2008-06-09 15:16 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: roles and inheritance
@ 2008-06-09 15:23 Julius Tuskenis <julius@nsoft.lt>
parent: Carol Walter <walterc@indiana.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Julius Tuskenis @ 2008-06-09 15:23 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-06-09 15:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-09 15:16 roles and inheritance Carol Walter <walterc@indiana.edu>
2008-06-09 15:23 ` Julius Tuskenis <julius@nsoft.lt>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox