Manage PostgreSQL roles and privileges from YAML or LDAP
Project description
Swiss-army knife to synchronize Postgres roles and privileges from YAML or LDAP.
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 privileges statically or from LDAP entries.
Dry run.
Logs LDAP queries as ldapsearch commands.
Logs every SQL queries.
Reads settings from an expressive YAML config file.
Here is a sample configuration and execution:
$ cat docs/ldap2pg.minimal.yml
- role:
name: ldap_roles
options: NOLOGIN
- ldap:
base: ou=people,dc=ldap,dc=ldap2pg,dc=docker
filter: "(objectClass=organizationalRole)"
role:
name: '{cn}'
options: LOGIN
parent: ldap_roles
$ ldap2pg --config docs/ldap2pg.minimal.yml --real
Starting ldap2pg 4.9.
Using .../docs/ldap2pg.minimal.yml.
Running in real mode.
Inspecting roles in Postgres cluster...
Querying LDAP ou=people,dc=ldap,dc=lda... (objectClass...
Create albert.
Create alter.
Create didier.
Create dorothée.
Create ldap_roles.
Update options of alan.
Update options of alice.
Add missing ldap_roles members.
Delete spurious ldap_roles members.
Reassign oscar objects and purge ACL on appdb.
Reassign oscar objects and purge ACL on olddb.
Drop oscar.
Synchronization complete.
$
See versionned ldap2pg.yml and documentation for further options.
Installation
Install it from PyPI tarball:
pip install ldap2pg
More details can be found in documentation.
ldap2pg is licensed under PostgreSQL license. ldap2pg is available with the help of wonderful people, jump to contributors list to see them.
Support
If you need support and you didn’t found it in documentation, just drop a question in a GitHub issue! Don’t miss the cookbook. You’re welcome!
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-4.11.tar.gz.
File metadata
- Download URL: ldap2pg-4.11.tar.gz
- Upload date:
- Size: 27.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | addb3e8968e3022f2ccbc6c742cde8a4c389046ba5ab0bd83cdee382aa87db79 |
|
| MD5 | 6337fb76626b5a3369eae972bc420cb9 |
|
| BLAKE2b-256 | 5e6f8eaa6fc2f03cf135260463e32763f715e2a0e848fa8bf47913329fca256f |
File details
Details for the file ldap2pg-4.11-py2.py3-none-any.whl.
File metadata
- Download URL: ldap2pg-4.11-py2.py3-none-any.whl
- Upload date:
- Size: 36.3 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 48d45f6ddd92e9928f979cad8e0e8c53104a0a72329d05e2636d52a2834ec8cb |
|
| MD5 | 3e1539ed06398c593226234f75bba912 |
|
| BLAKE2b-256 | 99d4e1f2023052255079333c418f40efd72e3b3ffb4c06735564cdd087986d92 |
