sys.sysoledbusers (Transact-SQL)
Ważne: |
---|
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.
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. |