Privileges

To provide a wide range of control, DB2 provides many privileges that are divided into the following categories:

For each category, you can grant these privileges (and authorities) to an ID:

Collection	Database	Distinct Type	Function	JAR File	Package	Plan
CREATE PACKADM	DBADM DBCTRL DBMAINT CREATETAB CREATETS DISPLAYDB DROP IMAGCOPY LOAD RECOVERDB REORG REPAIR STARTDB STATS STOPDB	USAGE	EXECUTE	USAGE	ALL BIND COPY EXECUTE	BIND EXECUTE

Schema	Sequences	Stored Procedure	System	Table or View	Use
ALTERIN CREATEIN DROPIN	ALTER USAGE	EXECUTE	ACCESSCTRL ARCHIVE BINDADD BINDAGENT BSDS CREATE_SECURE_OBJECT CREATEALIAS CREATEDBA CREATEDBC CREATESG CREATETMTAB DATAACCESS DISPLAY EXPLAIN MONITOR1 MONITOR2 RECOVER SQLADM STOPALL STOSPACE SYSADM SYSCTRL SYSOPR System DBADM TRACE	ALL ALTER DELETE INDEX INSERT REFERENCES SELECT TRIGGER1 UPDATE	USE OF BUFFERPOOL USE OF STOGROUP USE OF TABLE SPACE