spool all_usrs.rslt 

set linesize 80;
set pagesize 1000;
set long 50;
set echo on;

break on "OWNER" on "TBL - NAME";

/* ****************************************************** */
/*                                                        */
/* substitute the table_name variable with the new        */
/* name in CAPITAL LETTERS                                */
/*  - will show all the users for a given database        */
/*                                                        */
/*         @c:\oracle\sql\all_usrs.sql                    */ 
/*                                                        */
/* ****************************************************** */

select 	substr(username,1,8)			"USERNAME",
	substr(user_id,1,8)			"USER ID",
	substr(default_tablespace,1,12)		"TBL SPC",
	substr(temporary_tablespace,1,12)	"TEMP SPC",
	created					"CREATED",
	substr(profile,1,12)			"ROLE"
from 	dba_users 
order by 1 asc;

set echo off;
spool off;
set long 80;
commit;









