In Postgres Pro AXE, the administrator role
is called metastore_admin. It can interact with
pgpro_axe,
execute ETL operations,
and grant other users privileges to manage objects.
To configure the administrator role:
Create the metastore_admin role:
ALTER SYSTEM SET duckdb.postgres_role TO 'metastore_admin';
Grant the metastore_admin role full
access to the pgpro_metastore schema
and reload the pgpro_metastore server.