Find Oracle User Created Time



Share this article :

In Oracle, login into the SQL and execute below command to find the user created time.

SQL> select NAME, CTIME from sys.user$;

NAME                           CTIME
------------------------------ ---------------
SYS                            26-JUL-10
PUBLIC                         26-JUL-10
CONNECT                        26-JUL-10
RESOURCE                       26-JUL-10
DBA                            26-JUL-10

To find specific user, execute below command

SQL> select NAME, CTIME from sys.user$ where name='SYS';

NAME                           CTIME
------------------------------ ---------------
SYS                            26-JUL-10

Related posts

Interacting with an Oracle Database
Difference: JRE & JDK
V$ARCHIVE DEST STATUS: Archive Log Destination Runtime & Setting
ORA-00600: internal error code, arguments: [kccsbck_first], [1], []
© 2017 ITsiti. All Rights Reserved
Powered by KEEM