Chapter 14. Access Management

Since pgpro_metastore has its own objects, a system based on proxy tables is used to differentiate privileges and granularly manage access to these objects.

Proxy tables are empty tables without columns created in the pgpro_metastore schema. Each proxy table name is in the prefix_name format, where:

  • prefix: The prefix determining the object encapsulated by the proxy table.

    Possible values:

  • name: The name of the object encapsulated by the proxy table.

For example, the name of a proxy table can be s_localstorage.

Proxy tables are created and deleted simultaneously with objects that they encapsulate.

For more information about configuring access to the Postgres Pro AXE DBMS, refer to the official Postgres Pro documentation.