Lists users, their password creation dates, and how many days the password is valid from the creation date.
sp_iqlistpasswordexpirations ['userid']
userid Lists password creation time and days until password expiration for the specified user.
By default, this procedure returns a list of password creation time and days until password expiration for each user.
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_iqlistpasswordexpirations".
Cause: A user without DBA role tried to execute sp_iqlistpasswordexpirations.
sp_iqlistpasswordexpirations
UserName Password_Created Days_til_Expiration ------- ---------------- ------------------- DBA 2006-01-02 10:13:53.625 Expired rose 2006-01-05 14:36:38.099 180 jack 2006-01-07 14:44:34.645 0 Password_Expiration_Interval ---------------------------- 90 365 0
A value of 0 for Days_till_Expiration indicates that the password does not expire.
