10.4. Administrative Authorities

Once the user is successfully authenticated, DB2 checks to see if the user has the proper authority for the requested operations, such as performing database manager maintenance operations and managing database objects. Figure 10.12 shows the authorities supported in DB2 and Table 10.7 describes each of them.

Table 10.7. Descriptions of DB2 Administrative Authority Levels
DB2 Administrative AuthorityDescription
SYSADMThese users have the highest authority level and full privileges for managing the instance. They also have access to all data in the underlying databases.
SYSCTRLThese users have certain privileges in managing the instance, its databases, and database objects. They can create new databases, but do not ...

Get Understanding DB2®: Learning Visually with Examples now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.