Return
-
Title
Spotlight permissions with DB2 v9.5 -
Description
Question:
What are permissions granted to users who use Spotlight for DB2 v9.5 or higher? -
Resolution
ANSWER:
In order to use Spotlight on DB2 on DB2 v 9.5, user must have DBADM authority or execute authority to those table functions: WLM_GET_ACTIVITY_DETAILS
WLM_GET_QUEUE_STATS
WLM_GET_SERVICE_CLASS_AGENTS
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES
WLM_GET_SERVICE_SUBCLASS_STATS
WLM_GET_SERVICE_SUPERCLASS_STATS
WLM_GET_WORK_ACTION_SET_STATS
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES
WLM_GET_WORKLOAD_STATS