Thread: LDAP autos in postgres

LDAP autos in postgres

From
Yambu
Date:
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 

Re: LDAP autos in postgres

From
Holger Jakobs
Date:
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
Attachment

Re: LDAP autos in postgres

From
Yambu
Date:
Thanks Holmer, great answer.

On Fri, May 28, 2021 at 12:13 PM Holger Jakobs <holger@jakobs.com> wrote:
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