DB2 10.5 for Linux, UNIX, and Windows

Default PUBLIC privilege for built-in routines

When a non-restrictive database is created, the special group PUBLIC is granted EXECUTE with GRANT to the majority of built-in routines.

The exceptions are listed in Table 1. All the listed routines are in the schema SYSPROC.

Table 1. Built-in routines with no default PUBLIC privilege
Routine Name	Routine Type
ADMIN_GET_INTRA_PARALLEL	Function
ADMIN_GET_MEM_USAGE	Function
ADMIN_GET_STORAGE_PATHS	Function
ADMIN_GET_TAB_COMPRESS_INFO	Function
ADMIN_GET_TAB_COMPRESS_INFO_V97	Function
ADMIN_GET_TAB_DICTIONARY_INFO	Function
ADMIN_SET_INTRA_PARALLEL	Procedure
AUDIT_ARCHIVE	Function
AUDIT_ARCHIVE	Procedure
AUDIT_DELIM_EXTRACT	Procedure
AUDIT_LIST_LOGS	Function
AUTOMAINT_GET_POLICYFILE	Procedure
AUTOMAINT_GET_POLICY	Procedure
AUTOMAINT_SET_POLICYFILE	Procedure
AUTOMAINT_SET_POLICY	Procedure
DB2_GET_CLUSTER_HOST_STATE	Function
DB2_GET_INSTANCE_INFO	Function
ENV_GET_DB2_EDU_SYSTEM_RESOURCES	Function
ENV_GET_DB2_SYSTEM_RESOURCES	Function
ENV_GET_NETWORK_RESOURCES	Function
ENV_GET_REG_VARIABLES	Function
ENV_GET_SYS_RESOURCES	Function
ENV_GET_SYSTEM_RESOURCES	Function
EVMON_UPGRADE_TABLES	Procedure
EXPLAIN_FROM_ACTIVITY	Procedure
EXPLAIN_FROM_CATALOG	Procedure
EXPLAIN_FROM_DATA	Procedure
EXPLAIN_FROM_SECTION	Procedure
MON_CAPTURE_ACTIVITY_IN_PROGRESS	Procedure
MON_COLLECT_STATS	Procedure
MON_FORMAT_LOCK_NAME	Function
MON_FORMAT_XML_COMPONENT_TIMES_BY_ROW	Function
MON_FORMAT_XML_METRICS_BY_ROW	Function
MON_FORMAT_XML_WAIT_TIMES_BY_ROW	Function
MON_GET_ACTIVITY_DETAILS	Function
MON_GET_ACTIVITY	Function
MON_GET_AGENT	Function
MON_GET_APPL_LOCKWAIT	Function
MON_GET_AUTO_MAINT_QUEUE	Function
MON_GET_AUTO_RUNSTATS_QUEUE	Function
MON_GET_BUFFERPOOL	Function
MON_GET_CF_CMD	Function
MON_GET_CF	Function
MON_GET_CF_WAIT_TIME	Function
MON_GET_CONNECTION_DETAILS	Function
MON_GET_CONNECTION	Function
MON_GET_CONTAINER	Function
MON_GET_DATABASE_DETAILS	Function
MON_GET_DATABASE	Function
MON_GET_EXTENDED_LATCH_WAIT	Function
MON_GET_EXTENT_MOVEMENT_STATUS	Function
MON_GET_FCM_CONNECTION_LIST	Function
MON_GET_FCM	Function
MON_GET_GROUP_BUFFERPOOL	Function
MON_GET_HADR	Function
MON_GET_INDEX	Function
MON_GET_INDEX_USAGE_LIST	Function
MON_GET_INSTANCE	Function
MON_GET_LOCKS	Function
MON_GET_MEMORY_POOL	Function
MON_GET_MEMORY_SET	Function
MON_GET_PAGE_ACCESS_INFO	Function
MON_GET_PKG_CACHE_STMT_DETAILS	Function
MON_GET_PKG_CACHE_STMT	Function
MON_GET_QUEUE_STATS	Function
MON_GET_REBALANCE_STATUS	Function
MON_GET_ROUTINE_DETAILS	Function
MON_GET_ROUTINE_EXEC_LIST	Function
MON_GET_ROUTINE	Function
MON_GET_RTS_RQST	Function
MON_GET_SECTION	Function
MON_GET_SECTION_OBJECT	Function
MON_GET_SECTION_ROUTINE	Function
MON_GET_SERVERLIST	Function
MON_GET_SERVICE_SUBCLASS_DETAILS	Function
MON_GET_SERVICE_SUBCLASS	Function
MON_GET_SERVICE_SUBCLASS_STATS	Function
MON_GET_SERVICE_SUPERCLASS_STATS	Function
MON_GET_TABLE	Function
MON_GET_TABLESPACE	Function
MON_GET_TABLESPACE_QUIESCER	Function
MON_GET_TABLESPACE_RANGE	Function
MON_GET_TABLE_USAGE_LIST	Function
MON_GET_TRANSACTION_LOG	Function
MON_GET_UNIT_OF_WORK_DETAILS	Function
MON_GET_UNIT_OF_WORK	Function
MON_GET_USAGE_LIST_STATUS	Function
MON_GET_UTILITY	Function
MON_GET_WORK_ACTION_SET_STATS	Function
MON_GET_WORKLOAD_DETAILS	Function
MON_GET_WORKLOAD	Function
MON_GET_WORKLOAD_STATS	Function
MON_INCREMENT_INTERVAL_ID	Procedure
MON_SAMPLE_SERVICE_CLASS_METRICS	Function
MON_SAMPLE_WORKLOAD_METRICS	Function
SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY	Procedure
SYSTS_ALTER	Procedure
SYSTS_CLEANUP	Procedure
SYSTS_CLEAR_COMMANDLOCKS	Procedure
SYSTS_CLEAR_EVENTS	Procedure
SYSTS_CONFIGURE	Procedure
SYSTS_CREATE	Procedure
SYSTS_DISABLE	Procedure
SYSTS_DROP	Procedure
SYSTS_ENABLE	Procedure
SYSTS_UPDATE	Procedure
SYSTS_UPGRADE_CATALOG	Procedure
SYSTS_UPGRADE_INDEX	Procedure
WLM_ALTER_MEMBER_SUBSET	Procedure
WLM_CANCEL_ACTIVITY	Procedure
WLM_CAPTURE_ACTIVITY_IN_PROGRESS	Procedure
WLM_COLLECT_STATS	Procedure
WLM_CREATE_MEMBER_SUBSET	Procedure
WLM_DROP_MEMBER_SUBSET	Procedure
WLM_GET_ACTIVITY_DETAILS	Function
WLM_GET_CONN_ENV	Function
WLM_GET_QUEUE_STATS	Function
WLM_GET_SERVICE_CLASS_AGENTS	Function
WLM_GET_SERVICE_CLASS_AGENTS_V97	Function
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES	Function
WLM_GET_SERVICE_CLASS_WORKLOAD_OCCURRENCES_V97	Function
WLM_GET_SERVICE_SUBCLASS_STATS	Function
WLM_GET_SERVICE_SUBCLASS_STATS_V97	Function
WLM_GET_SERVICE_SUPERCLASS_STATS	Function
WLM_GET_WORK_ACTION_SET_STATS	Function
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES	Function
WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES_V97	Function
WLM_GET_WORKLOAD_STATS	Function
WLM_GET_WORKLOAD_STATS_V97	Function
WLM_SET_CLIENT_INFO	Procedure
WLM_SET_CONN_ENV	Procedure