Find Oracle User Created Time

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

You May Also Like

Leave a Reply?