How to Find When a User’s Password Was Last Changed in Oracle

Someone reported a login error:

ORA-01017: invalid username/password; logon denied

If you suspect a password change has occurred without notification, you can quickly verify the last password change datetime in Oracle using the following query:

SELECT PASSWORD_CHANGE_DATE  
FROM DBA_USERS  
WHERE USERNAME = 'W3BUDDY';

Output Example:

PASSWORD_CHANGE_DATE  
--------------------  
2024-06-17 11:34:52

This confirms the exact date and time the password for user W3BUDDY was last modified. Ensure you have sufficient privileges to query the DBA_USERS view.

Also read this: