This release supports SQLAlchemy 2.0 or later
get_all_parameter_acls
get_parameter_acl
PgOjectType.DOMAIN
PgOjectType.PARAMETER
- Python 3.8 or later is required.
- The following arguments for
grant
andrevoke
are now keyword-only:grant_option
schema
arg_types
quote_subname
- The following arguments for
as_grant_statements
andas_revoke_statements
are now keyword-only:schema
arg_types
quote_subname
- The
type_
parameter foras_grant_statements
andas_revoke_statements
was renamed totype
. - Installing
pg-grant[sqlalchemy]
no longer installs psycopg2. Make sure you depend on a driver likesqlalchemy[postgresql]
(psycopg2) orsqlalchemy[postgresql_psycopg]
(psycopg 3).
pg_grant.__version__
, useimportlib.metadata
instead.pg_grant.__description__
, useimportlib.metadata
instead.pg_grant.__license__
, useimportlib.metadata
instead.pg_grant.__author__
, useimportlib.metadata
instead.pg_grant.__email__
, useimportlib.metadata
instead.
This release supports SQLAlchemy 1.4 and 2.0. The next release will require SQLAlchemy 2.0 or later
- Python 3.6 or later is required.
This release supports SQLAlchemy 1.3 and 1.4. The next release will require SQLAlchemy 1.4 or later
- ACLs for functions without any arguments (i.e.
arg_types=()
) could not be queried usingget_function_acl
.
0.3.2 - 2020-05-21
- Type annotations for
parse_acl
andparse_acl_item
.
0.3.1 - 2018-01-17
pg_grant
can be installed with setuptools v38.0+, which requiresinstall_requires
insetup.py
to be ordered.
0.3.0 - 2017-10-31
parse_acl
function to callparse_acl_item
on each item in a list.- Documentation on
parse_acl_item
about ensuringsubname
is a valid identifier if it is to be executed. get_all_column_acls
andget_column_acls
to get column ACLs.
- Renamed singular functions like
get_table_acls
toget_table_acl
. get_all_table_acls
andget_table_acl
also return views, materialized views, partitioned tables (PostgreSQL 10+), and foreign tables.grant
andrevoke
will quote the subname in privileges by default, to ensure it is a valid identifier. Usequote_subname=False
to disable.Privileges.as_revoke_statements
will revoke the privileges with grant options fully.get_all_function_acls
andget_function_acl
now return canonical type names, e.g. 'integer' instead of 'int4'. Thearg_types
parameter onget_function_acl
also canonicalizes user input.
0.2.0.post0 - 2017-10-24
Minor packaging changes.
0.2.0 - 2017-10-24
First release.