14.1. Configuring the Administrator Role #
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_adminrole:ALTER SYSTEM SET duckdb.postgres_role TO 'metastore_admin';
Grant the
metastore_adminrole full access to the pgpro_metastore schema and reload the pgpro_metastore server.