CredentialsCheck Example 1: A password should expire every month |
To specify that a password should expire after one month:
SELECT '' violated FROM CREDENTIALSCHECK WHERE CREATIONDATE < SYSDATE 30
Your password has expired. Please change it. |