Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id D0F95634D34 for ; Mon, 20 Apr 2009 11:21:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 49429-02-4 for ; Mon, 20 Apr 2009 11:21:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gattler.pezone.net (eisentraut.org [85.214.91.16]) by mail.postgresql.org (Postfix) with ESMTP id A73ED633E60 for ; Mon, 20 Apr 2009 11:20:34 -0300 (ADT) Received: from fsopti579.localnet (fsgw.f-secure.com [193.110.108.33]) by gattler.pezone.net (Postfix) with ESMTP id 2F24915F091A; Mon, 20 Apr 2009 14:20:32 +0000 (UTC) From: Peter Eisentraut To: pgsql-docs@postgresql.org Subject: Re: role hierarchy Date: Mon, 20 Apr 2009 17:20:34 +0300 User-Agent: KMail/1.11.2 (Linux/2.6.26-2-686; KDE/4.2.2; i686; ; ) Cc: ali haghighat References: <82bc8b440904200049m368efc4wccea0a5b275385ac@mail.gmail.com> In-Reply-To: <82bc8b440904200049m368efc4wccea0a5b275385ac@mail.gmail.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-15" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200904201720.34800.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.444 tagged_above=0 required=5 tests=AWL=0.444 X-Spam-Level: X-Archive-Number: 200904/44 X-Sequence-Number: 5132 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