CredentialsCheck Example 1: A password should expire every month

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.