Q
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close