Return
-
Title
Can I run Spotlight with read only access on the database? -
Description
I have read only access on the database. Can I install and run Spotlight on a database with read only access.
-
Resolution
No this is not possible.
You need at least read/write access to the schema where the Spotlight objects are installed.
You can create a database user which are having less privileges for example: A user that can not kill sessions.
Please have a look at solution SOL244621 to configure such a user:
https://support.quest.com/SUPPORT/index?page=solution&id=SOL24461
For additional explanation about the privileges the Spotlight user needs have a look at solution SOL4919:
https://support.quest.com/SUPPORT/index?page=solution&id=SOL4919