Skip to content

How to Check User Creation Date

  • by

User Creation Date

To check the creation date for a specific user, we can query ALL_USERS.

SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';

Session altered.

SQL> select created from all_users where username = 'HR';

CREATED
-------------------
2020-07-20 23:33:02

As you can see, the user is created as shown.

Leave a Reply

Your email address will not be published.