Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 17607650E8E for ; Wed, 2 Jul 2008 23:49:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 60113-03 for ; Wed, 2 Jul 2008 23:49:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from collaborativefusion.com (mx01.pub.collaborativefusion.com [206.210.89.201]) by postgresql.org (Postfix) with ESMTP id CEC7564FD64 for ; Wed, 2 Jul 2008 23:49:13 -0300 (ADT) Received: from Internal Mail-Server by mx01 (envelope-from bseklecki@collaborativefusion.com) with SMTP; 2 Jul 2008 21:50:30 -0500 Subject: Re: LDAP Authentication From: "Brian A. Seklecki (Mobile)" Reply-To: bseklecki@collaborativefusion.com To: Magnus Hagander Cc: Taha Ozket , pgsql-general@postgresql.org In-Reply-To: <4867B10C.40705@hagander.net> References: <6e4906da0806290644q40ab3253p27b83488861f66d2@mail.gmail.com> <4867B10C.40705@hagander.net> Content-Type: text/plain Organization: Collaborative Fusion, Inc. Date: Wed, 02 Jul 2008 22:50:35 -0400 Message-Id: <1215053435.9810.61.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.22.2 (2.22.2-2.fc9) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/127 X-Sequence-Number: 134706 On Sun, 2008-06-29 at 17:58 +0200, Magnus Hagander wrote: > This is not something you currently can do. We can only do LDAP > authentication, not authorization. There's no way to restrict it to a > particular group. We're very interested in this functionality (nss_ldap for PgSQL) -- so if there's a joint-development effort that we can contribute man-hours or development resources (challenge grant funding, hardware, etc.) to, let us know. ~BAS > One way to accomplish what you're trying to do is to have a script > that > synchronizes the members of the group to PostgreSQL accounts (account > name and role membership only), and still use LDAP for authentication. IMPORTANT: This message contains confidential information and is intended only for the individual named. If the reader of this message is not an intended recipient (or the individual responsible for the delivery of this message to an intended recipient), please be advised that any re-use, dissemination, distribution or copying of this message is prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.