Table of Contents
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:
s for storages
t for analytical tables
f for directories
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.