From: Julius Tuskenis <julius@nsoft.lt>
Cc: pgsql-admin@postgresql.org
Subject: Re: roles and inheritance
Date: Mon, 09 Jun 2008 18:23:19 +0300
Message-ID: <484D4AE7.60702@nsoft.lt> (raw)
In-Reply-To: <98544210-C479-4A14-9FF4-CD40BC789E6C@indiana.edu>
References: <98544210-C479-4A14-9FF4-CD40BC789E6C@indiana.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: julius@nsoft.lt
Subject: Re: roles and inheritance
In-Reply-To: <484D4AE7.60702@nsoft.lt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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