Find Oracle User Last Password Change Time

In Oracle, login in SQL and execute below command.

SQL> select NAME, PTIME from SYS.USER$;

NAME                           PTIME
------------------------------ ---------------
SYS                            07-FEB-12
PUBLIC
CONNECT
RESOURCE
DBA
SYSTEM                         07-FEB-12

To find a specific user, execute below command,

SQL> select NAME, PTIME from SYS.USER$ where NAME='SYS';

NAME                           PTIME
------------------------------ ---------------
SYS                            07-FEB-12

You May Also Like

Leave a Reply?