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 metastore
schema.
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_role
configuration parameter.
Example 22.2.
ALTER SYSTEM SET duckdb.postgres_role TO 'metastore_admin';