sys.sysoledbusers (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Important

This SQL Server 2000 system table is included in SQL Server 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.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

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.

See Also

Catalog Views (Transact-SQL)
Compatibility Views (Transact-SQL)