Find User Account Status in Oracle



Share this article :

In Oracle, you can find your account status. Login in SQL and execute below command.

SQL> select username, account_status from dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
SAPSR3                         OPEN
SYS                            OPEN
ITSITII                        OPEN
AYAMAS                         EXPIRED(GRACE)
SYSTEM                         LOCKED(TIMED)
OUTLN                          LOCKED(TIMED)

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
ORACLE_OCM                     LOCKED
DBSNMP                         LOCKED
DIP                            LOCKED
KACIPKAMB                      EXPIRED & LOCKED

10 rows selected.

Related posts

ORA-28001: the password has expired
ORA-27101: shared memory realm does not exist
Find Oracle Global Database Name
SP2-0750: You may need to set ORACLE_HOME to your Oracle
© 2017 ITsiti. All Rights Reserved
Powered by KEEM