CHOUDHARI

-- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-- 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;