Customer's environment restricts other users from creating objects in the sys schema.
Spotlight creats sys views in the sys schema for monitoring.
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.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy