-- -----------------------------------------------------------------------------------

-- File Name    : https://oracle-base.com/dba/monitoring/users.sql

-- Author       : Tim Hall

-- Description  : Displays information about all database users.

-- Requirements : Access to the dba_users view.

-- Call Syntax  : @users [ username | % (for all)]

-- Last Modified: 21-FEB-2005

-- -----------------------------------------------------------------------------------

SET LINESIZE 200 VERIFY OFF

COLUMN username FORMAT A20

COLUMN account_status FORMAT A16

COLUMN default_tablespace FORMAT A15

COLUMN temporary_tablespace FORMAT A15

COLUMN profile FORMAT A15

SELECT username,

       account_status,

       TO_CHAR(lock_date, 'DD-MON-YYYY') AS lock_date,

       TO_CHAR(expiry_date, 'DD-MON-YYYY') AS expiry_date,

       default_tablespace,

       temporary_tablespace,

       TO_CHAR(created, 'DD-MON-YYYY') AS created,

       profile,

       initial_rsrc_consumer_group,

       editions_enabled,

       authentication_type

FROM   dba_users

WHERE  username LIKE UPPER('%&1%')

ORDER BY username;

SET VERIFY ON