Is there a way to find the details related to when was the last time a user password was changed?
Userlevel 6
+18
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
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.