Check When Password Was Last Changed in Oracle

dbtut

6 years ago

The most recent password change date for users in the Oracle database is in the ptime field in the sys.user $ table. With a query like the following, we can find out when a user last changed the password.

in sys.user$ table;

NAME: user or role name
TYPE #: 0 means role, 1 means user
CTIME: date created
PTIME: last password change date
EXPTIME: the date the password was last expired
LTIME: the latest lock date
LCOUNT: how many times he/she entered his/her password incorrectly

SELECT name, ctime, ptime FROM sys.user$ WHERE name = 'write_user_name';

1	SELECT name, ctime, ptime FROM sys.user$ WHERE name = 'write_user_name';