Skip to main content

Is there a way to find the details related to when was the last time a user password was changed?

This query should get you the required info (needs to run as SYS user):

Select name, password_date "Password Changed date"
from sys.user$ A, sys.user_history$ B
where A.user# = B.user# 
order by password_date;


Hi @Srikanth 

Thank you for the details. What causes entries to be created in table user_history$? I am unable to see anything in the table in our demo environment. I changed the password of an account but still didn’t create an entry in the table.


Reply