Re: Strange Tables and packages were created in system tablespace and rollback tablespace.

Evidently someone must have installed the sqllab product. However, if they have been created in the system and the rollback tablespaces there are several things to note (and sorry to say so)

1 either this user has the resource role or unlimited tablespace privilege 2 and/or no tablespace quota have been defined 3 this would mean people would be still capable of creating objects outside the default tablespace.
4 so evidently they just used a backdoor the DBA (you?) left open, and the DBA is at much at fault as they are.

Right now the only solution is

set feedback off
set heading off pagesize 0
spool temp.sql
select 'drop '||object_type||' '||owner||'.'||object_name from dba_objects
where <any proper criteria>;

spool off
@temp.sql
host delete temp.sql

Hth,

Sybrand Bakker, Oracle DBA

"Chuan Zhang" <chuan_at_asiaonline.net> wrote in message news:n_Hr5.21$e12.1095800_at_news.interact.net.au...
> Hi, All,
>
> Could anyone help me to get rid of the strange tables and packages?
> I am pretty sure that those tables, views and packages were created
> yesterday. I want to know how they were created and how to remove them.
> Because they are owned by sys, public and another dba user "swbapps".
>
> The table and package names look like Oracle Administration professional
> ones. I think that it is hardly created by application developers. I
 found
> some of tables are put in rollback tablespace which is dedicated to
 rollback
> segments. (Note: I guarantee that all the user including system user are
> assigned to their default tablespaces and temporary tablespaces). I
 totally
> lost. I haven't done anything yesterday except using the Oracle Expert of
> OEM2.1.
>
> Thus, one more question: is it possible for Oracle Enterprise Manager2.1
 to
> create these objects?
>
> The following is the scenario (sorry for the long list). All the objects
 are
> started with "SQLAB"
>
> Thanks for your help and precious time.
>
>
>
> SQL> select owner, object_name, object_type, created, timestamp, secondary
> from all_objects where object_nam
> e like 'SQL%';
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> SYS SQLAB_ALL_JOBS VIEW 31-AUG-00
 2000-08-31:11:39:27
> N
> SYS SQLAB_DBA_CONST VIEW 31-AUG-00
 2000-08-31:11:39:28
> N
> RAINTS
>
> SYS SQLAB_DESCRIBE_ VIEW 31-AUG-00
 2000-08-31:11:39:27
> N
> DETAILS
>
> SYS SQLAB_FILE_SEGM VIEW 31-AUG-00
 2000-08-31:11:39:26
> N
> ENTS
>
> SYS SQLAB_FILE_TABL VIEW 31-AUG-00
 2000-08-31:11:39:27
> N
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> E_SEGMENTS
>
> SYS SQLAB_INDEXED_D VIEW 31-AUG-00
 2000-08-31:11:39:28
> N
> EPENDENCIES
>
> SYS SQLAB_IND_COLUM VIEW 31-AUG-00
 2000-08-31:11:39:26
> N
> NS
>
> SYS SQLAB_TABLES VIEW 31-AUG-00
 2000-08-31:11:39:27
> N
> SYS SQLAB_TABLE_ROW VIEW 31-AUG-00
 2000-08-31:11:39:28
> N
> S
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
>
> SYS SQLAB_TAB_COLUM VIEW 31-AUG-00
 2000-08-31:11:39:26
> N
> NS
>
> SYS SQLAB_UNINDEX_F VIEW 31-AUG-00
 2000-08-31:11:39:27
> N
> OREIGN_KEYS
>
> SYS SQLAB_VIEW_DEPE VIEW 31-AUG-00
 2000-08-31:11:39:27
> N
> NDENCY
>
> PUBLIC SQLAB_ALL_INDEX SYNONYM 31-AUG-00
 2000-08-31:11:39:28
> N
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> _COLUMNS
>
> PUBLIC SQLAB_ALL_JOBS SYNONYM 31-AUG-00
 2000-08-31:11:39:27
> N
> PUBLIC SQLAB_BASE_VERS SYNONYM 31-AUG-00
 2000-08-31:11:39:41
> N
> ION
>
> PUBLIC SQLAB_BKGD_JOB SYNONYM 31-AUG-00
 2000-08-31:11:39:36
> N
> PUBLIC SQLAB_COLLECTIO SYNONYM 31-AUG-00
 2000-08-31:11:39:29
> N
> N_DEFINITION
>
> PUBLIC SQLAB_DBA_CONST SYNONYM 31-AUG-00
 2000-08-31:11:39:28
> N
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> RAINTS
>
> PUBLIC SQLAB_DESCRIBE_ SYNONYM 31-AUG-00
 2000-08-31:11:39:27
> N
> DETAILS
>
> PUBLIC SQLAB_ERRORS_PK SYNONYM 31-AUG-00
 2000-08-31:11:39:35
> N
> G
>
>
> PUBLIC SQLAB_EXPLAIN SYNONYM 31-AUG-00
 2000-08-31:11:39:31
> N
> PUBLIC SQLAB_EXPLAIN_P SYNONYM 31-AUG-00
 2000-08-31:11:39:33
> N
> ICK
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
>
> PUBLIC SQLAB_EXPLAIN_T SYNONYM 31-AUG-00
 2000-08-31:11:39:32
> N
> REE
>
> PUBLIC SQLAB_FILE_SEGM SYNONYM 31-AUG-00
 2000-08-31:11:39:26
> N
> ENTS
>
> PUBLIC SQLAB_INDEXED_D SYNONYM 31-AUG-00
 2000-08-31:11:39:28
> N
> EPENDENCIES
>
> PUBLIC SQLAB_IND_COLUM SYNONYM 31-AUG-00
 2000-08-31:11:39:26
> N
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> NS
>
> PUBLIC SQLAB_LAB_TREE SYNONYM 31-AUG-00
 2000-08-31:11:39:32
> N
> PUBLIC SQLAB_PICK_PLAN SYNONYM 31-AUG-00
 2000-08-31:11:39:35
> N
> _TABLES
>
> PUBLIC SQLAB_PLAN_TABL SYNONYM 31-AUG-00
 2000-08-31:11:39:35
> N
> ES
>
> PUBLIC SQLAB_QUERY_DEF SYNONYM 31-AUG-00
 2000-08-31:11:39:29
> N
> INITIONS
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
>
> PUBLIC SQLAB_SCHEDULED SYNONYM 31-AUG-00
 2000-08-31:11:39:37
> N
> _COLLECTOR
>
> PUBLIC SQLAB_SQLAREA4 SYNONYM 31-AUG-00
 2000-08-31:11:39:30
> N
> PUBLIC SQLAB_SQLTEXT SYNONYM 31-AUG-00
 2000-08-31:11:39:31
> N
> PUBLIC SQLAB_TABLES SYNONYM 31-AUG-00
 2000-08-31:11:39:27
> N
> PUBLIC SQLAB_TABLE_ROW SYNONYM 31-AUG-00
 2000-08-31:11:39:28
> N
> S
>
> PUBLIC SQLAB_TAB_COLUM SYNONYM 31-AUG-00
 2000-08-31:11:39:27
> N
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> NS
>
> PUBLIC SQLAB_TRACE_FIL SYNONYM 31-AUG-00
 2000-08-31:11:39:40
> N
> E_IO
>
> PUBLIC SQLAB_TRACE_PAR SYNONYM 31-AUG-00
 2000-08-31:11:39:40
> N
> SE
>
> PUBLIC SQLAB_UNINDEX_F SYNONYM 31-AUG-00
 2000-08-31:11:39:27
> N
> OREIGN_KEYS
>
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> PUBLIC SQLAB_USER SYNONYM 31-AUG-00
 2000-08-31:11:39:32
> N
> PUBLIC SQLAB_VERSION SYNONYM 31-AUG-00
 2000-08-31:11:39:41
> N
> PUBLIC SQLAB_VIEW_DEPE SYNONYM 31-AUG-00
 2000-08-31:11:39:27
> N
> NDENCY
>
> SYSTEM SQLPLUS_PRODUCT TABLE 25-JUN-00
 2000-06-25:11:25:38
> N
> _PROFILE
>
> SWBAPPS SQLAB_ALL_INDEX FUNCTION 31-AUG-00
 2000-08-31:11:39:28
> N
> _COLUMNS
>
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> SWBAPPS SQLAB_BKGD_JOB PACKAGE 31-AUG-00
 2000-08-31:11:39:36
> N
> SWBAPPS SQLAB_BKGD_JOB PACKAGE BODY 31-AUG-00
 2000-08-31:11:39:36
> N
> SWBAPPS SQLAB_COLLECTIO TABLE 31-AUG-00
 2000-08-31:11:39:29
> N
> N_DEFINITION
>
> SWBAPPS SQLAB_COLLECTIO INDEX 31-AUG-00
 2000-08-31:11:39:29
> N
> N_DEFINITION_U1
>
> SWBAPPS SQLAB_ERRORS TABLE 31-AUG-00
 2000-08-31:11:39:32
> N
> SWBAPPS SQLAB_ERRORS_PK PACKAGE 31-AUG-00
 2000-08-31:11:39:35
> N
> G
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
>
> SWBAPPS SQLAB_ERRORS_PK PACKAGE BODY 31-AUG-00
 2000-08-31:11:39:35
> N
> G
>
> SWBAPPS SQLAB_EXPLAIN TABLE 31-AUG-00
 2000-08-31:11:39:31
> N
> SWBAPPS SQLAB_EXPLAIN_N INDEX 31-AUG-00
 2000-08-31:11:39:31
> N
> 1
>
> SWBAPPS SQLAB_EXPLAIN_P TABLE 31-AUG-00
 2000-08-31:11:39:33
> N
> ICK
>
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> SWBAPPS SQLAB_EXPLAIN_P INDEX 31-AUG-00
 2000-08-31:11:39:34
> N
> ICK_N1
>
> SWBAPPS SQLAB_EXPLAIN_P INDEX 31-AUG-00
 2000-08-31:11:39:34
> N
> ICK_U1
>
> SWBAPPS SQLAB_EXPLAIN_P INDEX 31-AUG-00
 2000-08-31:11:39:34
> N
> ICK_U2
>
> SWBAPPS SQLAB_EXPLAIN_T VIEW 31-AUG-00
 2000-08-31:11:39:32
> N
> REE
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
>
> SWBAPPS SQLAB_EXPLAIN_U INDEX 31-AUG-00
 2000-08-31:11:39:32
> N
> 1
>
> SWBAPPS SQLAB_LAB_TREE VIEW 31-AUG-00
 2000-08-31:11:39:32
> N
> SWBAPPS SQLAB_PICK_PLAN VIEW 31-AUG-00
 2000-08-31:11:39:34
> N
> _TABLES
>
> SWBAPPS SQLAB_PLAN_TABL VIEW 31-AUG-00
 2000-08-31:11:39:35
> N
> ES
>
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> SWBAPPS SQLAB_QUERY_DEF TABLE 31-AUG-00
 2000-08-31:11:39:28
> N
> INITIONS
>
> SWBAPPS SQLAB_QUERY_DEF INDEX 31-AUG-00
 2000-08-31:11:39:29
> N
> INITIONS_N1
>
> SWBAPPS SQLAB_SCHEDULED PACKAGE 31-AUG-00
 2000-08-31:11:39:36
> N
> _COLLECTOR
>
> SWBAPPS SQLAB_SCHEDULED PACKAGE BODY 31-AUG-00
 2000-08-31:11:39:36
> N
> _COLLECTOR
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
>
> SWBAPPS SQLAB_SQLAREA4 TABLE 31-AUG-00
 2000-08-31:11:39:30
> N
> SWBAPPS SQLAB_SQLAREA4_ INDEX 31-AUG-00
 2000-08-31:11:39:30
> N
> U1
>
> SWBAPPS SQLAB_SQLTEXT TABLE 31-AUG-00
 2000-08-31:11:39:30
> N
> SWBAPPS SQLAB_SQLTEXT_U INDEX 31-AUG-00
 2000-08-31:11:39:30
> N
> 1
>
> SWBAPPS SQLAB_TRACE_FIL PACKAGE 31-AUG-00
 2000-08-31:11:39:40
> N
> E_IO
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
>
> SWBAPPS SQLAB_TRACE_FIL PACKAGE BODY 31-AUG-00
 2000-08-31:11:39:40
> N
> E_IO
>
> SWBAPPS SQLAB_TRACE_PAR PACKAGE 31-AUG-00
 2000-08-31:11:39:40
> N
> SE
>
> SWBAPPS SQLAB_TRACE_PAR PACKAGE BODY 31-AUG-00
 2000-08-31:11:39:41
> N
> SE
>
> SWBAPPS SQLAB_USER TABLE 31-AUG-00
 2000-08-31:11:39:32
> N
>
> OWNER OBJECT_NAME OBJECT_TYPE CREATED TIMESTAMP
> S
> ---------- --------------- ------------------ --------- ------------------
 -
> -
> SWBAPPS SQLAB_USER_U1 INDEX 31-AUG-00
 2000-08-31:11:39:33
> N
> SWBAPPS SQLAB_USER_U2 INDEX 31-AUG-00
 2000-08-31:11:39:33
> N
>
>
>
>
> Chuan
>
>
>
>
Received on Fri Sep 01 2000 - 01:48:29 CDT