SYSOPR administrative authority

A user with the SYSOPR authority can issue all Db2 commands except ARCHIVE LOG, START DATABASE, STOP DATABASE, and RECOVER BSDS.

Begin general-use programming interface information.In addition, that user can run the DSN1SDMP utility and terminate any utility job. With the GRANT option, that user can grant these privileges to others.

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

Table 1. Included authorities and grantable privileges for SYSOPR authority
Included authorities None
Additional grantable privileges Privileges:
DISPLAY  RECOVER  STOPALL  TRACE
Privileges on routines:
DISPLAY  START  STOP

End general-use programming interface information.