roles and inheritance

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

Responses

Browse pgsql-admin by date

  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