Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Catalogs/ PG_USER_MAPPING
Updated on 2025-08-19 GMT+08:00
View PDF

PG_USER_MAPPING

PG_USER_MAPPING records mappings from local users to remote.

This system catalog is accessible only to users with the SYSADMIN permission. Common users can query the PG_USER_MAPPINGS view.

Table 1 PG_USER_MAPPING columns

Name

Type

Reference

Description

oid

oid

-

Row identifier (hidden attribute, which must be specified)

umuser

oid

oid in PG_AUTHID

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

umserver

oid

oid in PG_FOREIGN_SERVER

OID of the foreign server that contains the mapping

umoptions

text[]

-

User mapping specific options, expressed in a string in the format of keyword=value
Parent topic: System Catalogs