| title | sys.sysoledbusers (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/15/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | fe924c17-9cad-4b2b-8124-1e0fd82931e3 | ||||
| author | rothja | ||||
| ms.author | jroth |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Important
This [!INCLUDEssVersion2000] system table is included in [!INCLUDEssNoVersion] as a view for backward compatibility only. We recommend that you use catalog views instead.
Contains one row for each user and password mapping for the specified linked server. sysoledbusers is stored in the master database.
| Column name | Data type | Description |
|---|---|---|
| rmtsrvid | smallint | Security identification number (SID) of the server. |
| rmtloginame | nvarchar(128) | Name of the remote login that loginsid maps to for linked rmtservid. |
| rmtpassword | nvarchar(128) | Returns NULL. |
| loginsid | varbinary(85) | SID of the local login to be mapped. |
| status | smallint | If 1, the mapping should use the credentials of the user. |
| changedate | datetime | Date the mapping information was last changed. |
Catalog Views (Transact-SQL)
Compatibility Views (Transact-SQL)