Hi,
in a more tight customer scenario we try the get DMC 3.1.4 running.
According to this
Minimum database privileges required for Db2 KC page, I started with these permissions, but I still get
errors in the DMC which return errors ('Can't display data' Click on refresh to continue, which doesn't help)
GRANT CONNECT, SQLADM, IMPLICIT_SCHEMA ON DATABASE TO USER DMCMON ;
GRANT CREATETAB ON DATABASE TO USER DMCMON ;
GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO USER DMCMON ;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 TO USER DMCMON ;
GRANT EXECUTE ON PACKAGE NULLID.SYSSH100 TO USER DMCMON ;
GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO USER DMCMON ;
GRANT EXECUTE ON FUNCTION SYSPROC.* to user DMCMON;
GRANT EXECUTE ON PROCEDURE SYSIBM.SQLCAMESSAGECCSID to user DMCMON;
GRANT SELECT ON sysibm.sysdummy1 to USER DMCMON ;
GRANT SELECT ON sysibm.sysversions to USER DMCMON ;
GRANT SELECT ON SYSIBM.SYSUSERAUTH TO USER DMCMON ;
Of course DBADM with DATAACCESS could fix it all, but that is not allowed in this environment.
What are the minimal privileges and permissions on the database to monitor are needed to get basic monitoring
or advanced monitoring running?
Kind regards
------------------------------
Roland Schock
Distinguished Engineer
ARS Computer und Consulting GmbH
------------------------------
#Db2