From: John R Pierce <pierce@hogranch.com>
To: pgsql-general@postgresql.org
Subject: Re: LDAP Authentication
Date: Wed, 22 Apr 2015 15:06:23 -0700
Message-ID: <55381B5F.6050408@hogranch.com> (raw)
In-Reply-To: <CAAW2xfdT9gQA1DaU_d3YmKd++rjdaHZZcwi5CnXX25Ew4RyKiA@mail.gmail.com>
References: <CAAW2xfeLtuCKo4q2iN1buD+2wLOy8aNEvCdu--6jAvWJONJ4Gg@mail.gmail.com>
<553812EF.10608@hogranch.com>
<CAAW2xfdT9gQA1DaU_d3YmKd++rjdaHZZcwi5CnXX25Ew4RyKiA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: pierce@hogranch.com
Subject: Re: LDAP Authentication
In-Reply-To: <55381B5F.6050408@hogranch.com>
References: <CAAW2xfeLtuCKo4q2iN1buD+2wLOy8aNEvCdu--6jAvWJONJ4Gg@mail.gmail.com> <553812EF.10608@hogranch.com> <CAAW2xfdT9gQA1DaU_d3YmKd++rjdaHZZcwi5CnXX25Ew4RyKiA@mail.gmail.com> <55381B5F.6050408@hogranch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox