This discussion is archived
2 Replies Latest reply: Feb 11, 2013 12:55 PM by ***Anuj*** RSS

DBA_USERS is not showing created date

***Anuj*** Journeyer
Currently Being Moderated
I am not sure why dba_user is showing created as date mask

SQL> select username,created,profile,password_versions from dba_users order by 2;

USERNAME CREATED PROFILE PASSWORD
------------------------------ --------------------- ------------------------------ --------
SYS dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
SYSTEM dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
OUTLN dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
DIP dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
ORACLE_OCM dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
DBSNMP dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G
APPQOSSYS dd-mm-yyyy hh24:mi:ss DEFAULT 10G 11G

Any idea ?


TIA
Anuj

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points