sp_iqlistexpiredpasswords procedure

Function

Lists users with expired passwords.

Syntax

sp_iqlistexpiredpasswords

Permissions

DBA authority required.

See also

“sp_iqmodifyadmin procedure”

“sp_iqmodifylogin procedure”

Errors

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.

Example

call sp_iqlistexpiredpasswords

Expired_Users
jack
jill