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

Naveen Kumar
Naveen Kumar used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IS Operational Excellence Manager
Commented:
SELECT   name "Username", ptime "Password Changed"
FROM     SYS.user$
WHERE    type# = 1
ORDER BY ptime DESC;
Naveen KumarProduction Manager / Application Support Manager

Author

Commented:
I will verify the above and get back to you.

Thanks

Naveen KumarProduction Manager / Application Support Manager

Author

Commented:
ploubier, Thanks for your help.
Pierrick LOUBIERIS Operational Excellence Manager

Commented:
You're welcome !

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial