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.
| DB2 Administrative Authority | Description |
|---|---|
| SYSADM | These users have the highest authority level and full privileges for managing the instance. They also have access to all data in the underlying databases. |
| SYSCTRL | These 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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
