Cheeky Cockatoo

set linesize 132
set pagesize 80
col username format a20
col default_tablespace format a20
col temporary_tablespace format a20
col profile format a20
col account_status format a8
accept username1  char prompt "Enter the username:"
select username, default_tablespace, temporary_tablespace, created, profile, account_status
from dba_users
where username like upper('%&username1%');

select *
from dba_sys_privs
where grantee like upper('%&username1%');