Check user status in oracle database

Check user status in oracle database

Here with the use of below scripts you can check the status of particular user whether is open/locked or expired , you can check the date of expiry and lock when the user is get locked or when its going to expire.

 

SQL> select USERNAME,ACCOUNT_STATUS,LOCK_DATE,EXPIRY_DATE,PROFILE from dba_users where username like '&USERNAME';

Enter value for username: SYS

USERNAME         ACCOUNT_STATUS                   LOCK_DATE EXPIRY_DA  PROFILE
--------------- -------------------------------- --------- --------- -------------------
SYS             OPEN                                        07-SEP-18  ORA_DB_PROFILE

Leave a Reply

Your email address will not be published. Required fields are marked *