Lists users, their password creations dates, and how many days the password is valid from the creation date.
sp_iqlistpasswordexpirations
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_till_Expiration |
|---|---|---|
DBA |
2004-01-02 10:13:53.625 |
0 |
rose |
2004-01-05 14:36:38.099 |
365 |
jack |
2004-01-07 14:44:34.645 |
0 |
A value of 0 for Days_till_Expiration indicates that the password does not expire.
