role hierarchy

Lists: pgsql-docs
From: ali haghighat <ali(dot)haghighat(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: role hierarchy
Date: 2009-04-20 07:49:20
Message-ID: 82bc8b440904200049m368efc4wccea0a5b275385ac@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-docs

hi

does postgresql support role hierarchy and how?
does child inherit parent permissions?how?

thanks in advance


From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-docs(at)postgresql(dot)org
Cc: ali haghighat <ali(dot)haghighat(at)gmail(dot)com>
Subject: Re: role hierarchy
Date: 2009-04-20 14:20:34
Message-ID: 200904201720.34800.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-docs

On Monday 20 April 2009 10:49:20 ali haghighat wrote:
> does postgresql support role hierarchy and how?
> does child inherit parent permissions?how?

You can configure that in some detail. All of the options you describe are
supported. Start by reading the docs:

http://www.postgresql.org/docs/8.3/interactive/sql-grant.html