18.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.
Example 18.1.
CREATE ROLE metastore_admin;
Grant a Postgres Pro role full access to the
metastoreschema.Example 18.2.
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 18.3.
ALTER SYSTEM SET duckdb.postgres_role TO 'metastore_admin';