How to check Last Password Change Time for a user in Oracle

SELECT name,

ctime,

ptime

FROM sys.user$

WHERE name = 'SCOTT';

 

NAME

CTIME

PTIME

SCOTT

02-17-2006 07:49:06

02-17-2006 08:40:09

Comments