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*