-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -- AUTHOR : Sameer Choudhari -- DESCRIPTION : Display all database users details -- USAGE : @db_user_info.sql -- LAST MODIFIED : 17/03/2015 -- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ SET lines 220 pages 49999 COLUMN username format a30 COLUMN default_tablespace format a30 COLUMN temporary_tablespace format a30 COLUMN PROFILE format a30 SELECT username, account_status, lock_date, expiry_date, default_tablespace, temporary_tablespace, created, PROFILE FROM dba_users ORDER BY username;