Last Date of Password change

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.