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)
A view of all users in the database:
set pages 999 lines 100
col username format a20
col status format a8
col tablespace format a20
col temp_ts format a20
select username
, account_status status
, created
, default_tablespace tablespace
, temporary_tablespace temp_ts
from dba_users
order by username
/
Example output:
USERNAME STATUS CREATED TABLESPACE TEMP_TS
-------------------- -------- --------- -------------------- --------
ANDY OPEN 30-JAN-08 ANDY TEMP
ANONYMOUS EXPIRED 16-NOV-06 SYSAUX TEMP
CTXSYS EXPIRED 16-NOV-06 SYSAUX TEMP
DBSNMP EXPIRED 16-NOV-06 SYSAUX TEMP
.
.
.
EXFSYS EXPIRED 16-NOV-06 SYSAUX TEMP
SYSTEM OPEN 16-NOV-06 SYSTEM TEMP
TSMSYS EXPIRED 16-NOV-06 USERS TEMP
WMSYS EXPIRED 16-NOV-06 SYSAUX TEMP
XDB EXPIRED 16-NOV-06 SYSAUX TEMP
22 rows selected.
For more useful DBA queries click here.
| 