pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rafal Pietrak <rafal@ztk-rp.eu>
To: pgsql-general@postgresql.org
Subject: Re: LDAP Authentication
Date: Thu, 23 Apr 2015 09:08:28 +0200
Message-ID: <55389A6C.3040802@ztk-rp.eu> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>

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

view thread (30+ messages)  latest in thread

Message-ID: <55389A6C.3040802@ztk-rp.eu>
Permalink:  ../55389A6C.3040802@ztk-rp.eu/
Also on:    postgresql.org/message-id/55389A6C.3040802@ztk-rp.eu

 · 

reply

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: rafal@ztk-rp.eu
  Subject: Re: LDAP Authentication
  In-Reply-To: <55389A6C.3040802@ztk-rp.eu>
  References: <CAAW2xfeLtuCKo4q2iN1buD+2wLOy8aNEvCdu--6jAvWJONJ4Gg@mail.gmail.com> <553812EF.10608@hogranch.com> <CAAW2xfdT9gQA1DaU_d3YmKd++rjdaHZZcwi5CnXX25Ew4RyKiA@mail.gmail.com> <55381B5F.6050408@hogranch.com> <55389A6C.3040802@ztk-rp.eu>

* 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