22.2. Configuring the Postgres Pro AXE Administrator #
The Postgres Pro AXE administrator has privileges on all pgpro_metastore objects and can grant some of these privileges to other roles. You can designate any Postgres Pro role as the Postgres Pro AXE administrator.
To configure the Postgres Pro AXE administrator:
Grant a Postgres Pro role full access to the
metastoreschema.Example 22.1.
GRANT ALL ON SCHEMA metastore TO metastore_admin;
Designate the Postgres Pro role as the Postgres Pro AXE administrator using the
duckdb.postgres_roleconfiguration parameter.Example 22.2.
ALTER SYSTEM SET duckdb.postgres_role TO 'metastore_admin';