Skip to main content

Parse PostgreSQL privileges

Project description

PyPI Version Documentation Travis Coverage Python Version PostgreSQL Version License

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)

Authors

Documentation

For in-depth information, visit the documentation!

Development

pg_grant uses semantic versioning

Project details


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)

Uploaded Source

Built Distribution

pg_grant-0.4.0-py2.py3-none-any.whl (20.4 kB view details)

Uploaded Python 2 Python 3

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

Hashes for pg_grant-0.4.0.tar.gz
Algorithm Hash digest
SHA256 1dd86acfd55e02e20d22fed50b9c39ce2dfa7f11d26c575658b49f06155348d4
MD5 47744e8d1c867d020e539a358ff99a18
BLAKE2b-256 ad43bf438f7bea4b587d08fd6a9b0048d287617b3b1133422f5950175f0138e5

See more details on using hashes here.

Provenance

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

Hashes for pg_grant-0.4.0-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 a8ce43af0bf2775bca882739b46300bcd3d283914266410779e14c79dda92206
MD5 40dcc43c0dd9a3b06cf1f48861ca3208
BLAKE2b-256 b1f65fb9696cf942f67f0abf9c3efe2b64a90e871cd75449bb7b4c5c8d5f12f3

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page