Home > Oracle DBA > How to get the last password changed time for a oracle user

How to get the last password changed time for a oracle user

March 11, 2014

At times we may need to check when the password changed for a particular user. for this we can make use of a view user$(ptime column) owned by sys.

SELECT name,
ctime,
ptime
FROM sys.user$
WHERE name = ‘USER-NAME’;

CTIME Indicates – Creation Time
PTIME Indicates – Password Change Time

Advertisements
Categories: Oracle DBA
%d bloggers like this: