From: | Carol Walter <walterc(at)indiana(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | roles and inheritance |
Date: | 2008-06-09 15:16:46 |
Message-ID: | 98544210-C479-4A14-9FF4-CD40BC789E6C@indiana.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Julius Tuskenis | 2008-06-09 15:23:19 | Re: roles and inheritance |
Previous Message | Shane Ambler | 2008-06-09 14:39:19 | Re: Connecting from xp to linux server |