CredentialsCheck Example 1: A password should expire every month

Previous Next

See Also

To specify that a password should expire after one month:

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

SELECT '' violated FROM CREDENTIALSCHECK WHERE CREATIONDATE < SYSDATE – 30

3. In the constraint message, write:

Your password has expired. Please change it.