Objects in the SYS schema:
All v$ views are re-created, the exact number depends on the version of Oracle. These are not new objects, but we re-create them to cover the ones missed by Oracle.
New objects created in the SYS schema:
For all Oracle versions:
X$BH
X$KSUSECST
X$KSLES
X$KSLED
X$KSUSESTA
X$KSPPI
X$KSBDP
X$KSPPCV
X$KSQRS
X$KSLEI
X$KSLLT
X$KSLLD
X$KSMLRU
X$KCBFWAIT
X$KSMSP
X$KSQST
For Oracle 8+ versions:
X$KCBWDS
X$KCBWBPD
Additional for Oracle 8.1+ versions:
X$KTFBUE
X$KTFBFE
X$KTFBHC
Additional for Oracle 10+ versions:
X$KSXPIA
Objects created in the Spotlight schema:
TABLE quest_soo_event_categories
TABLE quest_soo_buffer_busy
TABLE quest_soo_PLAN_TABLE
TABLE quest_soo_lock_tree
TABLE quest_soo_version
TABLE quest_soo_sb_event
TABLE quest_soo_sb_buffer_busy
TABLE quest_soo_sb_io_stat
TABLE quest_soo_parse_time_track
PL/SQL Package quest_soo_pkg
Privileges / Grants created
Roles
connect
resource
Optional privileges
alter system
select any table
CREATE ANY SYNONYM *
DROP ANY SYNONYM *
CREATE PUBLIC SYNONYM *
DROP PUBLIC SYNONYM *
* This Role is granted by the Quest Central database objects installer. This is required to support Quest Central's implementation of the "Manage Access to Instance Objects." It is not required for normal product usage.If you wish to use Spotlight with a user other than the repository owner, these privileges are required to allow the object owner to grant permissions to the user using the "Manage Access to Instance Objects" functionality.
Alternatively, it is possible to install the database objects from scratch for another user.
There are checkboxes in both the Spotlight on Oracle User Wizard and the Quest Central Repository Manager for the user to decide whether these privileges will be granted to the Spotlight user. These privileges are used for killing sessions, executing explain plans and modifying Oracle parameters.
Select
Select on all the v$ and x$ objects listed above.
Object privileges
select on dba_temp_files
select any dictionary
select on obj$
select on ts$
select on fet$
select on uet$
select on file$
select on user$
select on seg$
select on undo$
select on dba_extents
select on dba_free_space
select on dba_indexes
select on dba_ind_columns
select on dba_tab_columns
select on dba_tab_privs
select on dba_jobs
select on dba_data_files
select on dba_objects
select on dba_jobs
select on dba_jobs_running
execute on dbms_system
execute on dbms_job
Note: The above list is correct for Spotlight on Oracle 3.10 / Quest Central 5.5. Earlier versions of Spotlight granted other privileges that could be considered to be security holes. These privileges were not required for Spotlight core functionality and have been removed.
