Workload administration authority (WLMADM)

WLMADM authority is the authority required to manage workload objects for a specific database. This authority allows you to create, alter, drop, comment on, and grant and revoke access to workload manager objects.

WLMADM authority can be granted by the security administrator (who holds SECADM authority) or a user who possesses ACCESSCTRL authority. WLMADM authority can be granted to a user, a group, a role, or to PUBLIC. WLMADM authority gives a user the ability to perform the following operations:
  • Create, alter, comment on, and drop the following workload manager objects:
    • Histogram templates
    • Service classes
    • Thresholds
    • Work action sets
    • Work class sets
    • Workloads
  • Grant and revoke workload privileges
  • Execute the built-in workload management routines.

WLMADM authority is a subset of the database administrator authority, DBADM.