Lists users with expired passwords.
sp_iqlistexpiredpasswords ['userid']
userid Returns a row if the specified user’s password has expired, or no results if the password has not expired.
By default, this procedure returns a list of users whose passwords have expired.
DBA authority required.
The following error may occur. Cause is listed after the error.
Permission denied: You do not have permission to execute the procedure "sp_iqlistexpiredpasswords".
Cause: A user without DBA role tried to execute sp_iqlistexpiredpasswords.
call sp_iqlistexpiredpasswords
Expired_Users |
|---|
jack |
jill |
