SELECT name,
ctime,
ptime
FROM sys.user$
WHERE name = 'SCOTT';
NAME
SCOTT
CTIME
02-17-2006 07:49:06
PTIME
02-17-2006 08:40:09