The user_mapping_options view provides information about options associated with user mappings.
| Column name | Data type | Description |
|---|---|---|
authorization_identifier |
sql_identifier |
The name of the user being mapped.PUBLIC – Public mapping. |
foreign_server_catalog |
sql_identifier |
The name of the current database in which the foreign server used by this mapping is defined. |
foreign_server_name |
sql_identifier |
The name of the foreign server used by this mapping. |
option_name |
sql_identifier |
The name of an option. |
option_value |
character_data |
The value of the option. Always NULL unless: the current user is the mapped user, or the mapping is for PUBLIC and the current user owns the server, or the current user is a superuser–protecting passwords stored in mapping options. |