Displaying the Account Status of All Users : dba_users « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. dba_users

Displaying the Account Status of All Users

   
SQL>
SQL> SELECT username, account_status
  2  FROM dba_users;

USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
JAVA2S                         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.








Related examples in the same category

1.Query dba_users table
2.Verifying Resource Consumer Group Membership of Users
3.Query dba_users table for default_tablespace and temporary_tablespace
4.Join dba_users, dba_sys_privs
5.Join dba_users, dba_tab_privs
6.Check user name and password for users