user detail

col external_name for a20

select username, account_status, default_tablespace, temporary_tablespace, created, profile,
password, lock_date, expiry_date, user_id, initial_rsrc_consumer_group, external_name
from dba_users
where username like upper( '%&LikeUser%' )
order by username
/