Lists user IDs that are locked out of the database.
sp_iqlistlockedusers
DBA authority required.
Lists the user IDs of all users that have been locked out the database with sp_iqlocklogin.
The following error may occur. Cause is listed after the error.
Permission denied: You do not have permission to execute the procedure "sp_iqlistlockedusers".
Cause: A user without DBA role tried to execute sp_iqlistlockedusers.
call sp_iqlistlockedusers
Locked_Users |
|---|
rose |
