Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 700A99FA5E8 for ; Fri, 17 Aug 2007 14:05:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 04150-07 for ; Fri, 17 Aug 2007 14:05:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 1BDD79F9805 for ; Fri, 17 Aug 2007 14:05:16 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Fri, 17 Aug 2007 12:05:14 -0500 Message-Id: <46C58EF2.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Fri, 17 Aug 2007 12:05:07 -0500 From: "Kevin Grittner" To: "Peter Elmers" , Subject: Re: adding a user with the permission to create trimmed users References: <389EEEE3-3B4E-4B0C-B16B-7F61E8EDE76C@gmx.de> In-Reply-To: <389EEEE3-3B4E-4B0C-B16B-7F61E8EDE76C@gmx.de> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/203 X-Sequence-Number: 26534 >>> On Fri, Aug 17, 2007 at 4:50 AM, in message <389EEEE3-3B4E-4B0C-B16B-7F61E8EDE76C@gmx.de>, Peter Elmers wrote:=20 > I want to know whether there exist the possibility to create a user =20 > who has the permission to create users with preset limited permissions. >=20 > In detail: > I do not want that the admin user (a seperate limited one for the =20 > customer) is able to create full admin users or adequate ones. =20 Without more detail it is hard to give a specific answer, but it is = possible to grant a user the right to grant specific permissions. See: =20 http://www.postgresql.org/docs/8.2/interactive/sql-grant.html =20 http://www.postgresql.org/docs/8.2/interactive/sql-revoke.html =20 Pay particular attention to "WITH GRANT OPTION" and "WITH ADMIN OPTION", = as well as the discussion of the public group. (You will probably need to revoke some of the default rights of the public group.) =20 If you can't get it to work as desired, please post again with more specifics. =20 -Kevin =20