Return
-
Title
Database Privileges need for the Foglight DB2 agent -
Description
What privileges are needed from the DB2 cartridge end, in order to connect and monitor the DB2 database using the 5.7.5 DB2 cartridges?
Does the DB2 Agent requires any insert/update/delete statements on the monitored DB2?
-
Cause
The Agent monitors the DB2 databases via SQLs against the database, hence it requires minimum privileges to access the DB2 functions and tables/views.
Accessing the DB2 db is done in read only mode and the agent performs no insert/update/delete statements.
-
Resolution
Please refer to the latest Foglight for Databases deployment guide available for download from here for the list of database privileges for DB2 agent monitoring.