Postgres Pro AXE : Documentation: 1: Chapter 5. Configuring the Postgres Pro AXE Administrator : Postgres Professional

Chapter 5. Configuring the Postgres Pro AXE Administrator
Prev	Up	Part II. Quick Start	Home	Next

Chapter 5. Configuring the Postgres Pro AXE Administrator

Grant a Postgres Pro role full access to the metastore schema.
Example 5.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 5.2.
```
  ALTER SYSTEM SET duckdb.postgres_role TO 'metastore_admin';
```
Restart the Postgres Pro server.

For more detailed instructions, refer to Section 22.2.

Prev	Up	Next
Chapter 4. Installing Postgres Pro AXE	Home	Chapter 6. Defining a Metadata Catalog Connection (`define_catalog_connection`)

epub pdf