Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1231
  • Last Modified:

How to find out on what date oracle users have changed their password lastly ?

Hi,
 
I am trying to find out when the users in my ORACLE database have changed their passwords lastly. Basically, i want to find out when they changed their passwords for the last time ( recently changed date ).

Any data dictionary views or v$ views which we can query and get this information.

Waiting to hear from you experts !!

Thanks
0
Naveen Kumar
Asked:
Naveen Kumar
  • 2
  • 2
1 Solution
 
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
SELECT   name "Username", ptime "Password Changed"
FROM     SYS.user$
WHERE    type# = 1
ORDER BY ptime DESC;
0
 
Naveen KumarProduction Manager / Application Support ManagerAuthor Commented:
I will verify the above and get back to you.

Thanks

0
 
Naveen KumarProduction Manager / Application Support ManagerAuthor Commented:
ploubier, Thanks for your help.
0
 
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
You're welcome !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now