Hi, LDAP is often used to do a centralized user and role management in an enterprise environment. PostgreSQL offers different authentication methods, like LDAP, SSPI, GSSAPI or SSL. However, for any of these methods the user must already exist in the database, before the authentication can be used. There is currently no authorization of database users directly based on LDAP. Unfortunately, I couldn't find a programm for synchronizing users, groups and their memberships from LDAP to PostgreSQL. So I wrote my own and just released v0.1.0. Access to LDAP is used read-only. pg_ldap_sync issues proper CREATE ROLE, DROP ROLE, GRANT and REVOKE commands to synchronize users and groups. It is meant to be started as a cron job. FEATURES: * Configurable per YAML config file * Can use Active Directory as LDAP-Server * Nested groups/roles supported * Runs with pg.gem (C-library) or postgres-pr.gem (pure Ruby) * Test mode which doesn’t do any changes to the DBMS Homepage: https://github.com/larskanis/pg-ldap-sync Is it something useful for someone apart of mine? -- Kind regards, Lars Kanis -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
