pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLDAP autos in postgres
3+ messages / 2 participants
[nested] [flat]
* LDAP autos in postgres
@ 2021-05-28 09:20 Yambu <hyambu@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Yambu @ 2021-05-28 09:20 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: LDAP autos in postgres
@ 2021-05-28 10:13 Holger Jakobs <holger@jakobs.com>
parent: Yambu <hyambu@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Holger Jakobs @ 2021-05-28 10:13 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: LDAP autos in postgres
@ 2021-05-28 10:46 Yambu <hyambu@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
0 siblings, 0 replies; 3+ messages in thread
From: Yambu @ 2021-05-28 10:46 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-05-28 10:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-05-28 09:20 LDAP autos in postgres Yambu <hyambu@gmail.com>
2021-05-28 10:13 ` Holger Jakobs <holger@jakobs.com>
2021-05-28 10:46 ` Yambu <hyambu@gmail.com>
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