Several objects including tables, views and packages have to be created in the Spotlight schema for Spotlight on Oracle to operate successfully. Spotlight requires these objects to connect to monitored systems.
For a Spotlight user assigned the DBA role the following needs to be explicitly granted.
|Oracle 11g Release 2||If the Spotlight user has been assigned the Oracle DBA role then no other privileges are required to be granted before installing Spotlight objects.|
|Oracle 11g Release 1 and earlier||
For Oracle 11g Release 1 and earlier, several objects have to be created in the SYS schema for Spotlight on Oracle to operate successfully. See Objects in the SYS schema (Oracle 11g Release 1 and earlier) for more information.