Re:PostgreSQL's Imperfections
by nijave on Saturday April 04, 2020 @08:35AM
(#22777886)
You could just call it "ldap authentication". AD comes with an LDAP interface.
[ Parent
| on HN ]
Postgres does have ldap based auth, and also can authenticate against AD using sspi/gssapi.
The problem with that is that it requires users to have been created inside postgres first, and that you can't manage group membership inside AD.
yup, that's what I meant by authorisation, keeping the roles and groups in pgsql up to date.
Or Kerberos authentication (which AD also supports) https://www.postgresql.org/docs/current/gssapi-auth.html