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-01033: ORACLE initialization or shutdown in progress
V$ARCHIVE_DEST: Archived Redo Log Instance Destinations State
Find Oracle Shutdown & Startup Time
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
© 2018 ITsiti. All Rights Reserved
Powered by KEEM