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.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments