Re: LDAP authorization with postgresql - Mailing list pgsql-general

From Keith Brown
Subject Re: LDAP authorization with postgresql
Date
Msg-id CAPPhDfhkLhka42VYnahyZswk6o6gU02aCU8_WR0rYG0H9h6Zkw@mail.gmail.com
Whole thread Raw
In response to Re: LDAP authorization with postgresql  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
Yes, authentication with gss is great. Just authorization story with
postgresql is much harder. Should I even bother with LDAP? instead
just do it manually? I want to avoid another component like
pg-ldap-sync

On Fri, Oct 8, 2021 at 3:08 PM Stephen Frost <sfrost@snowman.net> wrote:
>
> Greetings,
>
> * Keith Brown (keith6014@gmail.com) wrote:
> > I use GSS for authentication. But I would like to setup LDAP based
> > authorization, so a user can have access to a particular
> > database/role/etc...I found documentation on how to setup LDAP but
> > don't really see any examples for what I am trying to do. Any
> > suggestions?
>
> You probably want to look into a tool to sync your LDAP directory group
> membership with roles in PG.
>
> eg: https://github.com/larskanis/pg-ldap-sync
>
> (Glad to hear you're using GSS for authentication!)
>
> Thanks,
>
> Stephen



pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: LDAP authorization with postgresql
Next
From: Anil
Date:
Subject: Error: server closed the connection unexpectedly