CredentialsCheck Example 2: Warn users that their password will expire within 10 days

Previous Next

See Also

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:

1. Specify that the CREDENTIALSCHECK table component is to manage authentication. See "Installing and Using the CredentialsCheck Table Component".
2. Add a corrective constraint in your application with the following SQL statement:

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