pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: LDAP autos in postgres
Date: Fri, 28 May 2021 12:13:23 +0200
Message-ID: <0c17f285-13c5-9202-1cba-df0ed58135c2@jakobs.com> (raw)
In-Reply-To: <CALhHtcDCFjdAQQHcsvNvbiJrvPi0EHzkk+GTuyfpfXaTEvm-fQ@mail.gmail.com>
References: <CALhHtcDCFjdAQQHcsvNvbiJrvPi0EHzkk+GTuyfpfXaTEvm-fQ@mail.gmail.com>

Am 28.05.21 um 11:20 schrieb Yambu:
> Hello
>
> Im new to LDAP authentication.
>
> May i please know where i setup user rights when im using LDAP 
> authentication? Is it in postgres or LDAP?
>
> regards

All users have to be set up in PostgreSQL  including all attributes 
(CREATEROLE ...) and privileges (GRANT ...)

LDAP only does the authentication of the users. If user names within 
PostgreSQL and LDAP don't match, you'll have to set up pg_ident.conf

Hope this helps.


-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Attachments:

  OpenPGP_signature (application/pgp-signature, 202B) download

view thread (3+ messages)  latest in thread

Message-ID: <0c17f285-13c5-9202-1cba-df0ed58135c2@jakobs.com>
Permalink:  ../0c17f285-13c5-9202-1cba-df0ed58135c2@jakobs.com/
Also on:    postgresql.org/message-id/0c17f285-13c5-9202-1cba-df0ed58135c2@jakobs.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
  Subject: Re: LDAP autos in postgres
  In-Reply-To: <0c17f285-13c5-9202-1cba-df0ed58135c2@jakobs.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