sys.remote_logins (Transact-SQL)
Applies to:
SQL Server
Returns a row per remote-login mapping. This catalog view is used to map incoming local logins that claim to be coming from a corresponding server to an actual local login.
Column name | Data type | Description |
---|---|---|
server_id | int | ID of the server in sys.servers. This name is supplied by the connection from the "remote" server. |
remote_name | sysname | Login name that the connection will supply to be mapped. If NULL, the login name that is specified in the connection is used. |
local_principal_id | int | ID of the server principal to whom the login is mapped. If 0, the remote login is mapped to the login with the same name. |
modify_date | datetime | Date the linked login was last changed. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Linked Servers Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
الملاحظات
https://aka.ms/ContentUserFeedback.
قريبًا: خلال عام 2024، سنتخلص تدريجيًا من GitHub Issues بوصفها آلية إرسال ملاحظات للمحتوى ونستبدلها بنظام ملاحظات جديد. لمزيد من المعلومات، راجعإرسال الملاحظات وعرضها المتعلقة بـ