User creation details in user$ table - Oracle Database Script. SELECT NAME, type#, ctime, ptime, exptime, ltime FROM sys.user$ WHERE NAME IN ('SYS', 'SYSTEM') ORDER BY NAME; NOTE: CTIME -> USER CREATION TIME PTIME -> LAST PASSWORD CHANGE TIME EXPTIME -> PASSWORD EXPIRY DATE LTIME - > ACCOUNT LOCK TIME
SELECT NAME, type#, ctime, ptime, exptime, ltime FROM sys.user$ WHERE NAME IN ('SYS', 'SYSTEM') ORDER BY NAME; NOTE: CTIME -> USER CREATION TIME PTIME -> LAST PASSWORD CHANGE TIME EXPTIME -> PASSWORD EXPIRY DATE LTIME - > ACCOUNT LOCK TIME