Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YlBFc-0001kF-Tf for pgsql-general@arkaria.postgresql.org; Thu, 23 Apr 2015 07:08:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YlBFb-0003Sq-1V for pgsql-general@arkaria.postgresql.org; Thu, 23 Apr 2015 07:08:43 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YlBFZ-0003Sj-HG for pgsql-general@postgresql.org; Thu, 23 Apr 2015 07:08:41 +0000 Received: from poczta.fidefinance.eu ([31.6.70.245] helo=zorro.ztk-rp.eu) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1YlBFW-0005UL-LC for pgsql-general@postgresql.org; Thu, 23 Apr 2015 07:08:39 +0000 Received: from nowszy.local ([192.168.1.224]) by zorro.ztk-rp.eu with esmtpsa (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128) (Exim 4.80) (envelope-from ) id 1YlBFM-0005HX-WC for pgsql-general@postgresql.org; Thu, 23 Apr 2015 09:08:29 +0200 Message-ID: <55389A6C.3040802@ztk-rp.eu> Date: Thu, 23 Apr 2015 09:08:28 +0200 From: Rafal Pietrak User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.6.0 MIME-Version: 1.0 To: pgsql-general@postgresql.org References: <553812EF.10608@hogranch.com> <55381B5F.6050408@hogranch.com> In-Reply-To: <55381B5F.6050408@hogranch.com> Content-Type: multipart/alternative; boundary="------------050206050103010306010301" X-SA-Exim-Connect-IP: 192.168.1.224 X-SA-Exim-Mail-From: rafal@ztk-rp.eu X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on zorro.ztk-rp.eu X-Spam-Level: X-Spam-Status: No, score=-1.0 required=5.0 tests=ALL_TRUSTED,HTML_MESSAGE autolearn=ham version=3.3.2 Subject: Re: LDAP Authentication X-SA-Exim-Version: 4.2.1 (built Mon, 26 Dec 2011 16:57:07 +0000) X-SA-Exim-Scanned: Yes (on zorro.ztk-rp.eu) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org This is a multi-part message in MIME format. --------------050206050103010306010301 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit W dniu 23.04.2015 o 00:06, John R Pierce pisze: > On 4/22/2015 2:57 PM, Joseph Kregloh wrote: >> >> >> >> I see. That would still require a manual process to create the user >> on each server. I was planing on using some already existing scripts >> to create the user automatically on all servers and then LDAP would >> authorize depending on attributes in their LDAP profile. > > but thats not how it works, so all the 'planing' in the world won't > change a thing. > > access rights per database are managed with GRANT, users must be > CREATE USER on each server regardless of how they are authenticated. > As I understand: 1. postgresql maintains whatever's GRANTed within its system tables. 2. postgresql supports DBLINK there was a way to supplement (join) system rights table with DBLINKed LDAP? -R --------------050206050103010306010301 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit W dniu 23.04.2015 o 00:06, John R Pierce pisze:
On 4/22/2015 2:57 PM, Joseph Kregloh wrote:


I see. That would still require a manual process to create the user on each server. I was planing on using some already existing scripts to create the user automatically on all servers and then LDAP would authorize depending on attributes in their LDAP profile.

but thats not how it works, so all the 'planing' in the world won't change a thing.

access rights per database are managed with GRANT, users must be CREATE USER on each server regardless of how they are authenticated.

As I understand:
1. postgresql maintains whatever's GRANTed within its system tables.
2. postgresql supports DBLINK

<whatif>
there was a way to supplement (join) system rights table with DBLINKed LDAP?
</whatif>

-R
--------------050206050103010306010301--