Return
-
Title
alternative install needed - does not allow user to create objects in sys schema -
Description
Customer's environment restricts other users from creating objects in the sys schema.
-
Cause
Spotlight creats sys views in the sys schema for monitoring.
-
Resolution
Spotlight needs to select from some X$ tables in order to gather performance statistics for the database. It is not possible to grant select access on these X$ tables directly, instead we must use a work around as documented by oracle in note “How To Give Grant Select On X$ Objects In Oracle 10g? [ID 453076.1]”. These are the only objects we create in the SYS schema, and Spotlight will not work without them. However, as you can see, Oracle recommends this method of querying X$ tables as a non-sys user so it should not be a problem.