CredentialsCheck Example 2: Warn users that their password will expire within 10 days |
To specify that a warning message should appear when a user logs in using a password that is due to expire within 10 days. The password is valid for 30 days following its specification:
update CREDENTIALSCHECK set TOKEN = to_char(floor((CREATIONDATE+30) - SYSDATE)) where SYSDATE > (CREATIONDATE + 20) AND SYSDATE <= (CREATIONDATE + 30)
3. In the constraint message, write: Your password will expire in <CREDENTIALSCHECK.TOKEN.value> days |