DB2 UDB grants for monitoring a restricted database


The following list describes the grants that are given to the configured default account user:

  • db2 GRANT EXECUTE ON FUNCTION SYSPROC.MON_GET_TABLESPACE to userName
  • db2 GRANT SELECT ON SYSIBMADM.CONTAINER_UTILIZATION to userName
  • db2 GRANT SELECT ON SYSIBMADM.PRIVILEGES to userName
  • db2 GRANT EXECUTE ON PACKAGE NULLID.SYSSH200 to userName
  • db2 GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD to userName

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*