Authorities and privileges

Db2 provides a hierarchy of authorities to assign a set of predefined administrative permissions, to perform database maintenance operations to groups or users. The following diagram showcases a hierarchical view of the authorities and privileges that are available in Db2 11.1.

Db2 authorities and privileges

Authorities

Db2 uses 12 different authorities to control how users perform administrative and maintenance tasks against an instance or a database. We will discuss each of these authorities in the following sections.

The system administrative authority (SYSADM)

...