Postgres Pro AXE : Documentation: 1: 22.1. Stored Procedures and Privileges : Postgres Professional

22.1. Stored Procedures and Privileges
Prev	Up	Chapter 22. Access Management	Home	Next

22.1. Stored Procedures and Privileges #

The table below specifies the security definer status and required privileges for all stored procedures. Security definer stored procedures are executed on behalf of the user that installed pgpro_metastore (in most cases, the superuser), but before execution, the privileges of the actual role are verified.

For more information, refer to:

Section 22.2 for configuring the Postgres Pro AXE administrator.
Section 22.4 for granting the SELECT and INSERT privileges.
The official Postgres Pro documentation for other privileges.

Stored Procedure	Security Definer	Privileges
`cleanup`		Postgres Pro AXE administrator only.
`define_catalog_connection`		Postgres Pro AXE administrator only.
`init`		Postgres Pro AXE administrator only.
`metastore.add_storage`		Postgres Pro AXE administrator only.
`metastore.remove_storage`		Postgres Pro AXE administrator only.
`metastore.add_table`		Postgres Pro AXE administrator only.
`metastore.rename_table`		Postgres Pro AXE administrator only.
`metastore.create_view`		`SELECT` privilege on the analytical table. `CREATE` privilege on the Postgres Pro schema that contains the view.
`metastore.remove_table`		Postgres Pro AXE administrator only.
`metastore.add_column`		Postgres Pro AXE administrator only.
`metastore.rename_column`		Postgres Pro AXE administrator only.
`metastore.change_column_type`		Postgres Pro AXE administrator only.
`metastore.delete_column`		Postgres Pro AXE administrator only.
`metastore.add_schema`		Postgres Pro AXE administrator only.
`metastore.remove_schema`		Postgres Pro AXE administrator only.
`metastore.add_folder`		Postgres Pro AXE administrator only.
`metastore.remove_folder`		Postgres Pro AXE administrator only.
`metastore.add_files`		`INSERT` privilege on the analytical table. `SELECT` privilege on the shared directory if Parquet files are added from this directory.
`metastore.copy_table`		`INSERT` privilege on the analytical table. The privilege required to execute the SQL command passed as the second parameter.
`metastore.expire_snapshot_on_time`		Postgres Pro AXE administrator only.
`metastore.expire_snapshot_on_ids`		Postgres Pro AXE administrator only.
`metastore.delete_expired_files`		Postgres Pro AXE administrator only.
`metastore.mgrant`		`GRANT` privilege on the proxy table.
`metastore.mrevoke`		`REVOKE` privilege on the proxy table.
`metastore.pgpro_build`		All roles.

Prev	Up	Next
Chapter 22. Access Management	Home	22.2. Configuring the Postgres Pro AXE Administrator

epub pdf