The user_mappings view provides information about all 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. |