sp_validatelogins (Transact-SQL)
Applies to: SQL Server
Reports information about Windows users and groups that are mapped to SQL Server principals but no longer exist in the Windows environment.
Transact-SQL syntax conventions
Syntax
sp_validatelogins
[ ; ]
Return code values
0
(success) or 1
(failure).
Result set
Column name | Data type | Description |
---|---|---|
SID |
varbinary(85) | Windows security identifier (SID) of the Windows user or group. |
NT Login |
sysname | Name of the Windows user or group. |
Remarks
If the orphaned server-level principal owns a database user, the database user must be removed before the orphaned server principal can be removed. To remove a database user, use DROP USER. If the server-level principal owns securables in the database, ownership of the securables must be transferred or they must be dropped. To transfer ownership of database securables, use ALTER AUTHORIZATION.
To remove mappings to Windows users and groups that no longer exist, use DROP LOGIN.
Permissions
Requires membership in the sysadmin or securityadmin fixed server role.
Examples
The following example displays the Windows users and groups that no longer exist but are still granted access to an instance of SQL Server.
EXEC sp_validatelogins;
GO
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho