12.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:
Create a Postgres Pro role or use an existing one.
For example:
CREATE ROLE metastore_admin;
Grant a Postgres Pro role full access to the
metastoreschema.For example:
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.For example:
ALTER SYSTEM SET duckdb.postgres_role TO 'metastore_admin';