Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ User and Permission Management/ 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 system administrators. 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	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 the current mapping.
umoptions	text[]	-	User mapping specific options, expressed in a string in the format of keyword=value

Parent topic: User and Permission Management

Previous topic: PG_SHSECLABEL

Next topic: PG_USER_STATUS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel