DBA_USERS
DBA_USERSビューの仕様
SQL> desc dba_users;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 USERNAME                                  NOT NULL VARCHAR2(30)
 USER_ID                                   NOT NULL NUMBER
 PASSWORD                                           VARCHAR2(30)
 ACCOUNT_STATUS                            NOT NULL VARCHAR2(32)
 LOCK_DATE                                          DATE
 EXPIRY_DATE                                        DATE
 DEFAULT_TABLESPACE                        NOT NULL VARCHAR2(30)
 TEMPORARY_TABLESPACE                      NOT NULL VARCHAR2(30)
 CREATED                                   NOT NULL DATE
 PROFILE                                   NOT NULL VARCHAR2(30)
 INITIAL_RSRC_CONSUMER_GROUP                        VARCHAR2(30)
 EXTERNAL_NAME                                      VARCHAR2(4000)
 
SQL>

ACCOUNT_STATUS
  • OPEN
  • EXPIRED
  • EXPIRED(GRACE)
  • LOCKED(TIMED)
  • LOCKED
  • EXPIRED & LOCKED(TIMED)
  • EXPIRED(GRACE) & LOCKED(TIMED)
  • EXPIRED & LOCKED
  • EXPIRED(GRACE) & LOCKED
SQL> col username format a15
SQL> col account_status format a20
SQL> col default_tablespace format a10
SQL> col temporary_tablespace format a10
SQL> col profile format a15
SQL> select username,account_status,expiry_date,default_tablespace,temporary_tablespace,profile,initial_rsrc_consumer_group 
from dba_users;
 
USERNAME        ACCOUNT_STATUS       EXPIRY_DA DEFAULT_TA TEMPORARY_ PROFILE         INITIAL_RSRC_CONSUMER_GROUP
--------------- -------------------- --------- ---------- ---------- --------------- ------------------------------
OUTLN           OPEN                           SYSTEM     TEMP       DEFAULT         DEFAULT_CONSUMER_GROUP
SYS             OPEN                           SYSTEM     TEMP       DEFAULT         SYS_GROUP
SYSTEM          OPEN                           SYSTEM     TEMP       DEFAULT         SYS_GROUP
DBSNMP          OPEN                           SYSAUX     TEMP       DEFAULT         DEFAULT_CONSUMER_GROUP
TSMSYS          EXPIRED & LOCKED               SYSTEM     TEMP       DEFAULT         DEFAULT_CONSUMER_GROUP
DIP             EXPIRED & LOCKED               SYSTEM     TEMP       DEFAULT         DEFAULT_CONSUMER_GROUP
ORACLE_OCM      EXPIRED & LOCKED               SYSTEM     TEMP       DEFAULT         DEFAULT_CONSUMER_GROUP
 
7 rows selected.
 
SQL>
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License