• 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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