Authorization ID privileges: SETSESSIONUSER
Authorization ID privileges involve actions on authorization
IDs. There is currently only one such privilege: the SETSESSIONUSER
privilege.
Schema privileges
Schema privileges are in the object privilege category.
Table space privileges
The table space privileges involve actions on the table
spaces in a database. A user can be granted the USE privilege for
a table space, which then allows them to create tables within the
table space.
Table and view privileges
Table and view privileges involve actions on tables or
views in a database.
Package privileges
A package is a database object that contains the information
needed by the database manager to access data in the most efficient
way for a particular application program. Package privileges enable
a user to create and manipulate packages.
Index privileges
The creator of an index or an index specification
automatically receives CONTROL privilege on the index. CONTROL privilege
on an index is really the ability to drop the index. To grant CONTROL
privilege on an index, a user must have ACCESSCTRL or SECADM authority.
Sequence privileges
The creator of a sequence automatically receives the USAGE
and ALTER privileges on the sequence. The USAGE privilege is needed
to use NEXT VALUE and PREVIOUS VALUE expressions for the sequence.
Routine privileges
Execute privileges involve actions on all types of routines
such as functions, procedures, and methods within a database. Once
having EXECUTE privilege, a user can then invoke that routine, create
a function that is sourced from that routine (applies to functions
only), and reference the routine in any DDL statement such as CREATE
VIEW or CREATE TRIGGER.
Usage privilege on workloads
To enable use of a workload, a user who
holds ACCESSCTRL, SECADM, or WLMADM authority can grant USAGE privilege
on that workload to a user, a group, or a role using the GRANT USAGE
ON WORKLOAD statement.