Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yl2mz-0003uQ-Ga for pgsql-general@arkaria.postgresql.org; Wed, 22 Apr 2015 22:06:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yl2my-0001eJ-Uu for pgsql-general@arkaria.postgresql.org; Wed, 22 Apr 2015 22:06:36 +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 1Yl2mx-0001bp-0i for pgsql-general@postgresql.org; Wed, 22 Apr 2015 22:06:35 +0000 Received: from hogranch.com ([75.101.82.47]) by makus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1Yl2mu-0003ZX-PQ for pgsql-general@postgresql.org; Wed, 22 Apr 2015 22:06:33 +0000 Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id t3MM6SH22126 for ; Wed, 22 Apr 2015 15:06:28 -0700 Message-ID: <55381B5F.6050408@hogranch.com> Date: Wed, 22 Apr 2015 15:06:23 -0700 From: John R Pierce User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: LDAP Authentication References: <553812EF.10608@hogranch.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------080603020309080106050007" X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean 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. --------------080603020309080106050007 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit 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. -- john r pierce, recycling bits in santa cruz --------------080603020309080106050007 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
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.

-- 
john r pierce, recycling bits in santa cruz
--------------080603020309080106050007--