Synchronize PostgreSQL roles from LDAP
Project description
PostgreSQL roles and ACL management
Swiss-army knife to synchronize Postgres roles and ACLs from any LDAP directory.
Features
Creates, alter and drops PostgreSQL roles from LDAP queries.
Creates static roles from YAML to complete LDAP entries.
Manage role members (alias groups).
Grant or revoke custom ACL statically or from LDAP entries.
Dry run.
Logs LDAP queries as ldapsearch commands.
Logs every SQL queries.
Reads settings from YAML config file.
$ cat ldap2pg.yml
sync_map:
ldap:
base: ou=people,dc=ldap2pg,dc=local
filter: "(objectClass=organizationalRole)"
attribute: cn
role:
name_attribute: cn
options: LOGIN
$ ldap2pg --real
Using ./ldap2pg.yml.
Using /home/.../src/dalibo/ldap2pg/ldap2pg.yml.
Starting ldap2pg 1.0.
Running in real mode.
Inspecting Postgres...
Querying LDAP cn=dba,ou=groups,dc=ldap2pg,dc=local...
Querying LDAP ou=groups,dc=ldap2pg,dc=local...
Create alan.
Create dave.
Create david.
Create ldap_users.
Add ldap_users members.
Add missing backend members.
Delete spurious backend members.
Update options of alice.
Would reassign oscar objects and purge ACL on backend.
Would reassign oscar objects and purge ACL on frontend.
Would reassign oscar objects and purge ACL on legacy.
Would reassign oscar objects and purge ACL on postgres.
Would reassign oscar objects and purge ACL on template1.
Drop oscar.
Synchronization complete.
$
See versionned ldap2pg.yml for further options.
Installation
Install it from PyPI tarball:
pip install ldap2pg
ldap2pg is licensed under PostgreSQL license.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file ldap2pg-2.0a3.tar.gz.
File metadata
- Download URL: ldap2pg-2.0a3.tar.gz
- Upload date:
- Size: 15.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 51dd33daf252c3d1ff39ebd68bccc3dd0d910e8aa21646211c959cc3d5554cb7 |
|
| MD5 | 7d0254452a7645c86a80d01a3fde16ce |
|
| BLAKE2b-256 | 40cb0e17b379271eef1cc2437b54aa568a3924c43abd642e988a5660fa22bdfe |
File details
Details for the file ldap2pg-2.0a3-py2.py3-none-any.whl.
File metadata
- Download URL: ldap2pg-2.0a3-py2.py3-none-any.whl
- Upload date:
- Size: 20.7 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 426fb1be5174bc94c97fce7d250a45c1f8d91d14a0e67c58de351a31f0c6fe26 |
|
| MD5 | 05621942bd8247fdef3859288cdefc1d |
|
| BLAKE2b-256 | 404e5f6d45040a6b81708981429048e4958f5c1ca846251dd418e397c40e33b0 |
