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;