_PG_USER_MAPPINGS
Stores mappings from local users to remote users, as described in Table 1. Only the sysadmin user has the permission to view this view.
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 located (always the current database) |
foreign_server_name |
information_schema.sql_identifier |
Name of the foreign server. |
srvowner |
information_schema.sql_identifier |
Owner of the foreign server. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot