Home Dashboard Directory Help
Search

Add an option to sp_validatelogin to return Win Auth logins that are present but disabled in AD by BMLowery


Status: 

Closed


1
0
Sign in
to vote
Type: Suggestion
ID: 795294
Opened: 7/29/2013 9:57:27 AM
Access Restriction: Public
0
Workaround(s)
view

Description

sp_validatelogin only returns Win Auth logins not present in AD. This request is to add a bit parameter that will allow the caller to return Win Auth logins that are present but disabled in AD. One possible use case is for forensic analysis when we want to completely remove a login temporarily from SQL Server while we investigate/monitor, the idea being that we may reenable it or not pending the analysis results.
Details
Sign in to post a comment.
Sign in to post a workaround.