Types

class pg_grant.types.PgObjectType

Bases: enum.Enum

PostgreSQL object type.

class pg_grant.types.Privileges(grantee, grantor, privs=NOTHING, privswgo=NOTHING)

Bases: object

Stores information from a parsed privilege string.

See also

parse_acl_item()

as_grant_statements(type_: pg_grant.types.PgObjectType, target, **kwargs)

Return array of grant() statements that can be executed to grant these privileges. Refer to the function documentation for the meaning of target and additional keyword arguments.

Note

This requires installing with the sqlalchemy extra.

as_revoke_statements(type_: pg_grant.types.PgObjectType, target, **kwargs)

Return array of revoke() statements that can be executed to revoke these privileges. Refer to the function documentation for the meaning of target and additional keyword arguments.

Note

The statement for the privswgo privileges will revoke them fully, not only their grant options.

Note

This requires installing with the sqlalchemy extra.

class pg_grant.types.RelationInfo(oid, name, owner, acl)

Bases: object

Holds object information and privileges as queried using the query submodule.

oid

Row identifier.

name

Name of the table, sequence, etc.

owner

Owner of the relation.

acl

Access control list.

class pg_grant.types.SchemaRelationInfo(oid, name, owner, acl, schema)

Bases: pg_grant.types.RelationInfo

Holds object information and privileges as queried using the query submodule.

schema

The name of the schema that contains this relation.

class pg_grant.types.FunctionInfo(oid, name, owner, acl, schema, arg_types)

Bases: pg_grant.types.SchemaRelationInfo

Holds object information and privileges as queried using the query submodule.

arg_types

Data types of the function arguments.

class pg_grant.types.ColumnInfo(table_oid, schema, table, column, owner, acl)

Bases: object

Holds object information and privileges as queried using the query submodule.

table_oid

Table identifier.

schema

The name of the schema that contains the table.

table

Name of the table.

column

Name of the column.

owner

Owner of the table.

acl

Column access control list.