List Users

List users

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
/

Output:
USERNAME             STATUS   CREATED         TABLESPACE           TEMP_TS
-------------------- -------- --------------- -------------------- --------------------
A123                 OPEN     14-JUL-10       MGIXX_DATA           TEMP
A127                 OPEN     01-SEP-10       MGIXX_DATA           TEMP
A205                 EXPIRED( 14-JUL-10       MGIXX_DATA           TEMP
                     GRACE)
A213                 LOCKED(T 04-AUG-10       MGIXX_DATA           TEMP
                     IMED)