Task	Authority required
Alias - Add, change, or delete	SYSADM DBADM for the database where the alias is stored Owner of the alias ALTERIN privilege on the schema to which the alias belongs
Alias - Create	SYSADM DBADM for the database where you store the alias
Alias - Drop	SYSADM DBADM for the database where the alias is stored Owner of the alias DROPIN privilege on the schema to which the alias belongs
Database - Create or change	SYSADM SYSCTRL
Database - Create from a backup image	SYSADM SYSCTRL SYSMAINT
Database - Grant authority	To grant DBADM authority: SYSADM To grant all other authorities: SYSADM DBADM
Database - Connect	SYSADM DBADM
Database - Restore	SYSADM SYSCTRL
Database - Roll forward	SYSADM SYSCTRL SYSMAINT
Index - Change comments	SYSADM DBADM Control privilege on the index or table DROPIN privilege on the index schema
Index - Create	SYSADM DBADM Implicit_Schema authority on the database CREATEIN privilege on the schema one of the following privileges for the table on which the index is created: Control privilege Index privilege
Index - Grant control privileges	SYSADM DBADM
Schema - Alter	SYSADM DBADM
Schema - Create	SYSADM DBADM You can create a schema using a schema name or authorization name that matches your authorization ID
Schema - Grant privileges	SYSADM DBADM
Table - Alter	ALTER privilege CONTROL privilege SYSADM DBADM ALTERIN privilege on the table schema
Table - Copy	On the source table: SYSADM DBADM Select privilege On the target database: CREATETAB and connect privileges SYSADM DBADM
Table - Create	CREATETAB privilege plus one of: SYSADM DBADM Implicit_Schema authority on the database if the implicit or explicit schema name of the table does not exist CREATEIN privilege on the schema if the schema name of the table exists
Table - Drop	CONTROL privilege SYSADM DBADM DROPIN privilege on the table schema Defined in the DEFINER column of SYSCAT.TABLES as the definer
Table - Define a foreign key	CONTROL privilege SYSADM DBADM REFERENCES privilege on the table
Table - Add or drop a foreign key	CONTROL privilege SYSADM DBADM REFERENCES privilege on the table
Table - Drop the primary key	CONTROL privilege SYSADM DBADM ALTER privilege ALTERIN privilege on the table schema
Table - Export data to an output file	SYSADM DBADM CONTROL privilege for the table or view SELECT privilege for the table or view
Table - Import a file	Using the INSERT option: SYSADM DBADM CONTROL privilege on the table INSERT and SELECT privilege on the table Using INSERT_UPDATE, REPLACE, OR REPLACE_CREATE option for a table that exists: SYSADM DBADM CONTROL privilege on the table Using CREATE or REPLACE_CREATE for a table that does not exist: SYSADM DBADM CREATETAB privilege
Table - Load data	SYSADM DBADM
Table - Grant privileges	SYSADM DBADM To grant CONTROL privileges on user-defined tables: SYSADM DBADM To grant all other privileges on user-defined tables: SYSADM DBADM CONTROL privilege on the table The privilege you want to grant and the GRANT option
Table - Change quiesce mode	SYSADM SYSCTRL SYSMAINT DBADM
Table - Reorganize	SYSADM SYSCTRL SYSMAINT DBADM CONTROL privilege on the table
Table - Rename	SYSADM DBADM CONTROL privilege on the table
Table - Run statistics	SYSADM SYSCTRL SYSMAINT DBADM CONTROL privilege on the table
Triggers - Add, change or delete a comment	SYSADM DBADM ALTERIN privilege on the schema to which the trigger belongs
View - Alter	SYSADM DBADM ALTERIN privilege on the view schema CONTROL privilege on the view
View - Create	SYSADM DBADM CONTROL or SELECT privilege on the table and one of the following privileges: IMPLICIT_SCHEMA on the database if the implicit or explicit schema name of the view does not exist CREATEIN on the schema, if the schema name of the view exists
View - Drop	SYSADM DBADM DROPIN privilege on the view schema CONTROL privilege on the view
View - Grant privileges	SYSADM DBADM To grant CONTROL privileges on user-defined views: SYSADM DBADM To grant all other privileges on user-defined views: SYSADM DBADM CONTROL privilege on the table The privilege you want to grant and the GRANT option
View - Show related	SYSADM DBADM SELECT privilege on the system catalog views