Parse PostgreSQL privileges
Project description
pg_grant is a Python module for parsing, querying, and updating PostgreSQL privileges.
Installation
$ pip install pg_grant[sqlalchemy]
Without the SQLAlchemy extra, pg_grant can only parse access privileges.
Example
>>> from pg_grant import parse_acl_item
>>> parse_acl_item('bob=arw*/alice')
Privileges(grantee='bob', grantor='alice', privs=['SELECT', 'INSERT'], privswgo=['UPDATE'])
>>> from sqlalchemy import create_engine
>>> from pg_grant.query import get_table_acl
>>> engine = create_engine('postgresql://...')
>>> get_table_acl(engine, 'table2')
SchemaRelationInfo(oid=138067, name='table2', owner='alice', acl=['alice=arwdDxt/alice', 'bob=arwdDxt/alice'], schema='public')
>>> from pg_grant import PgObjectType
>>> from pg_grant.sql import revoke
>>> stmt = revoke(['SELECT'], PgObjectType.TABLE, 'table2', 'bob')
>>> str(stmt)
'REVOKE SELECT ON TABLE table2 FROM bob'
>>> engine.execute(stmt)
Documentation
For in-depth information, visit the documentation!
Development
pg_grant uses semantic versioning
Project details
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
pg_grant-0.4.0.tar.gz
(29.0 kB
view details)
Built Distribution
File details
Details for the file pg_grant-0.4.0.tar.gz
.
File metadata
- Download URL: pg_grant-0.4.0.tar.gz
- Upload date:
- Size: 29.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.10.7
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1dd86acfd55e02e20d22fed50b9c39ce2dfa7f11d26c575658b49f06155348d4 |
|
MD5 | 47744e8d1c867d020e539a358ff99a18 |
|
BLAKE2b-256 | ad43bf438f7bea4b587d08fd6a9b0048d287617b3b1133422f5950175f0138e5 |
File details
Details for the file pg_grant-0.4.0-py2.py3-none-any.whl
.
File metadata
- Download URL: pg_grant-0.4.0-py2.py3-none-any.whl
- Upload date:
- Size: 20.4 kB
- Tags: Python 2, Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.10.7
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | a8ce43af0bf2775bca882739b46300bcd3d283914266410779e14c79dda92206 |
|
MD5 | 40dcc43c0dd9a3b06cf1f48861ca3208 |
|
BLAKE2b-256 | b1f65fb9696cf942f67f0abf9c3efe2b64a90e871cd75449bb7b4c5c8d5f12f3 |