Query To Find Out Password Expiration?
Posted on 2006-10-25
In my Oracle 8i database, I have set up a profile that requires users to change their password every 90 days (policy requires it, and sarbanes/oxley enforces it.) My users change their password using a 3rd party tool. If the don't change it, it simply locks them out without warning.
Is there a query I can run, that will tell me when a user's password is about to expire, so I can send them an automatic email that it's nearly time to change their password again?