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

Previous Next

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