Name
|
Null
|
Type
|
USER#
|
NOT NULL
|
NUMBER
|
NAME
|
NOT NULL
|
NUMBER
|
TYPE#
|
NOT NULL
|
VARCHAR2(30)
|
PASSWORD
|
|
NUMBER
|
DATATS#
|
NOT NULL
|
NUMBER
|
TEMPTS#
|
NOT NULL
|
DATE
|
CTIME
|
NOT NULL
|
DATE
|
PTIME
|
|
DATE
|
EXPTIME
|
|
DATE
|
LTIME
|
|
NUMBER
|
RESOURCE$
|
NOT NULL
|
VARCHAR2(38)
|
AUDIT$
|
|
NUMBER
|
DEFROLE
|
NOT NULL
|
NUMBER
|
DEFGRP#
|
|
NUMBER
|
DEFGRP_SEQ#
|
|
NUMBER
|
ASTATUS
|
NOT NULL
|
NUMBER
|
LCOUNT
|
NOT NULL
|
VARCHAR2(30)
|
DEFSCHCLASS
|
|
VARCHAR2(4000)
|
EXT_USERNAME
|
|
NUMBER
|
SPARE1
|
|
NUMBER
|
SPARE2
|
|
NUMBER
|
SPARE3
|
|
VARCHAR2(1000)
|
SPARE4
|
|
VARCHAR2(1000)
|
SPARE5
|
|
DATE
|
SPARE6
|
|
NUMBER
|
USER#
|
NOT NULL
|
VARCHAR2(30)
|
NAME
|
NOT NULL
|
NUMBER
|
TYPE#
|
NOT NULL
|
NUMBER
|
PASSWORD
|
|
DATE
|
DATATS#
|
NOT NULL
|
DATE
|
TEMPTS#
|
NOT NULL
|
DATE
|
CTIME
|
NOT NULL
|
DATE
|
PTIME
|
|
NUMBER
|
EXPTIME
|
|
VARCHAR2(38)
|
LTIME
|
|
NUMBER
|
RESOURCE$
|
NOT NULL
|
NUMBER
|
AUDIT$
|
|
NUMBER
|
DEFROLE
|
NOT NULL
|
NUMBER
|
DEFGRP#
|
|
NUMBER
|
DEFGRP_SEQ#
|
|
VARCHAR2(30)
|
ASTATUS
|
NOT NULL
|
VARCHAR2(4000)
|
SELECT name, ctime, ptime FROM sys.user$ WHERE name = ‘USER-NAME’;
Thank you
Osama