Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ System Catalogs and System Views/ System Views/ User and Permission Management/ PG_USER_MAPPINGS
Updated on 2024-06-03 GMT+08:00
View PDF
Share

PG_USER_MAPPINGS

PG_USER_MAPPINGS displays user mapping information. All users can view the information.

Table 1 PG_USER_MAPPINGS columns

Name

Type

Reference

Description

umid

oid

oid in PG_USER_MAPPING

OID of the user mapping.

srvid

oid

oid in PG_FOREIGN_SERVER

OID of the foreign server that contains the mapping.

srvname

name

srvname in PG_FOREIGN_SERVER

Name of the foreign server.

umuser

oid

oid in PG_AUTHID

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

usename

name

-

Name of the local user to be mapped.

umoptions

text[]

-

User mapping specific options. If the current user is the owner of the foreign server, the value is keyword=value strings. Otherwise, the value is NULL.