user_system_tab.sql

rem Script Description: This script returns a list of users who own objects in the SYSTEM tablespace other than SYS & SYSTEM. 
rem                     The SYSTEM tablespace is used by Oracle for administration of the RDBMS. Users should NEVER use 
rem                     the SYSTEM tablespace.
rem
rem Output file:        uis.lis
rem
rem Prepared By:        TheOracleResourceStop Script Archive
rem                     www.orsweb.com
rem
rem Usage Information:  SQLPLUS SYS/pswd
rem                     @usrsinsystem.sql
rem

set pages 1000;

spool uis.lis

select owner,'TABLE' object_type,substr(table_name,1,40) object_name,substr(tablespace_name,1,10) tablespace_name
from dba_tables
where owner not in ('SYS','SYSTEM','PUBLIC')
  and tablespace_name = 'SYSTEM'
union
select owner,'INDEX' object_type,substr(index_name,1,40) object_name, substr(tablespace_name,1,10) tablespace_name
from dba_indexes
where owner not in ('SYS','SYSTEM','PUBLIC')
  and tablespace_name = 'SYSTEM'
order by 1,3;
spool off;