Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Displaying the Account Status of All Users

SQL> SQL> SELECT username, account_status   2  FROM dba_users; USERNAME                       ACCOUNT_STATUS ------------------------------ -------------------------------- RNTSOFT                         OPEN SYS                            OPEN SYSTEM                         OPEN ANONYMOUS                      OPEN MDSYS                          EXPIRED & LOCKED OUTLN                          EXPIRED & LOCKED DIP                            EXPIRED & LOCKED TSMSYS                         EXPIRED & LOCKED FLOWS_FILES                    EXPIRED & LOCKED CTXSYS                         EXPIRED & LOCKED DBSNMP                         EXPIRED & LOCKED USERNAME                       ACCOUNT_STATUS ------------------------------ -------------------------------- FLOWS_020100                   EXPIRED & LOCKED XDB                            EXPIRED & LOCKED HR                             EXPIRED & LOCKED 14 rows selected.