• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_USER_MAPPING

PG_USER_MAPPING

PG_USER_MAPPING stores the mappings from local users to remote.

Common users cannot access this catalog. Use the view PG_USER_MAPPINGS instead.

Table 1 PG_USER_MAPPING columns

Name

Type

Reference

Description

oid

oid

-

Column identifier (hidden attribute; must be explicitly selected)

umuser

oid

PG_AUTHID.oid

OID of the local role being mapped, 0 if the user mapping is public

umserver

oid

PG_FOREIGN_SERVER.oid

OID of the foreign server that contains this mapping

umoptions

text[]

-

Option used for user mapping. It is a keyword=value string.