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

V$ARCHIVE DEST STATUS: Archive Log Destination Runtime & Setting
Identified which Parameters been Modified after Oracle Instance Startup
Find the Location of Oracle SPFILE
OPatch: Prerequisite check "CheckActiveFilesAndExecutables"
© 2018 ITsiti. All Rights Reserved
Powered by KEEM