Message-ID: <484D4AE7.60702@nsoft.lt>
Date: Mon, 09 Jun 2008 18:23:19 +0300
From: Julius Tuskenis <julius@nsoft.lt>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
CC: pgsql-admin@postgresql.org
Subject: Re: roles and inheritance
References: <98544210-C479-4A14-9FF4-CD40BC789E6C@indiana.edu>
In-Reply-To: <98544210-C479-4A14-9FF4-CD40BC789E6C@indiana.edu>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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