Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ Schemas/ Information Schema/ _PG_USER_MAPPINGS
Updated on 2025-07-15 GMT+08:00
View PDF
Share

_PG_USER_MAPPINGS

Stores mappings from local users to remote users. Only the SYSADMIN user has the permission to view this view.

Table 1 _PG_USER_MAPPINGS columns

Name

Type

Description

oid

oid

OID of the mapping from the local user to a remote user.

umoptions

text[]

User mapping specific options, expressed in a string in the format of keyword=value.

umuser

oid

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

authorization_identifier

information_schema.sql_identifier

Role of the local user.

foreign_server_catalog

information_schema.sql_identifier

Name of the database where the foreign server is defined in.

foreign_server_name

information_schema.sql_identifier

Name of the foreign server.

srvowner

information_schema.sql_identifier

Owner of the foreign server.
Parent topic: Information Schema