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 system-defined workload management routines.
WLMADM authority is a subset of the database
administrator authority, DBADM.