Skip to content

How to Check Password Change DateTime

  • Oracle

Someone reported a login error:

According to his report, he's pretty sure that the password is correct. Most likely, someone changed it without notifying anyone.

To know when the password of an user have been changed, we can lookup PASSWORD_CHANGE_DATE column in DBA_USERS.

SQL> select password_change_date from dba_users where username = 'HR';

PASSWORD_CHANGE_DAT
-------------------
2023-12-30 14:48:25

The modified datetime of the password is confirmed.

Leave a Reply

Your email address will not be published. Required fields are marked *