— usr_lst.sql
— mdw 8/8/97

— simple list of users and their defaults

set pause on pause ‘Any Key…>’
set pages 24
col username form A12 word wrap
spool usr_lst.lst
select username, user_id, substr(default_tablespace,1,15) dflt_tabspace, substr(temporary_tablespace,1,15) temp_tabspace, created
from sys.dba_users
where username like upper(‘&usr_nm’||’%’)
order by 1,2
/
spool off