Evaluate
Weigh the pros and cons of technologies, products and projects you are considering.
When were the SYS/SYSTEM passwords last changed?
How can I find out what date the SYS/SYSTEM passwords have been last changed on?
How can I find out what date the SYS/SYSTEM passwords have been last changed on? Is it the CTIME in SYS.USER$?
The CTIME column of SYS.USER$ is the date and time the user was created. So this value does not help you.
I know of no way to determine the actual date and time the password was last changed. However, you can set up a profile for your users to expire passwords after a certain number of days. The EXPIRY_DATE column of DBA_USERS will show you when the password will expire next. To determine when the user changed their password last, simply subtract the password lifetime value from the expiration date.
