📋Steps in this guide1/1

User creation details in user$ table

SELECT NAME, type#, ctime, ptime, exptime, ltime FROM sys.user$ WHERE NAME IN ('SYS', 'SYSTEM') ORDER BY NAME;

oracle configurationintermediate

by OracleDba

13 views

User creation details in user$ table

Code/Command (click line numbers to comment):

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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!