DBCTRL administrative authority

The DBCTRL authority includes the DBMAINT privileges on a specific database. A user with the DBCTRL authority can run utilities that can change the data.

Begin general-use programming interface information. If the value of the DBADM CREATE AUTH field on the DSNTIPP installation panel is set to YES during the Db2 installation, an ID with DBCTRL authority can create an alias for another user ID on any table in the database.

If a user has the DBCTRL authority with the GRANT option, that user can grant those privileges to others.

The following tables summarizes any included authorities, and privileges held and grantable to others, by the DBCTRL administrative authority.

Table 1. Included authorities and grantable privileges for DBCTRL authority
Included authorities	DBMAINT
Additional grantable privileges	Privileges on a database: DROP LOAD RECOVERDB REORG REPAIR

End general-use programming interface information.