Verifying database privileges

Verify that you have the necessary privileges to access the database in each runtime environment you are migrating.

The following table describes the database privileges that are needed to modify existing database schemas and data for use with IBM® Business Process Manager V8.0.1.

Important:

Because the upgrade process drops all SIB tables for the Messaging Engine database, the user must have the DROP TABLE privilege on those SIB tables (for both Process Server and Performance Data Warehouse).
If the user that performs the upgrade is the user that set up the IBM Business Process Manager server, it already has all necessary privileges on the existing tables. If you have revoked any privileges on the table level, such as ALTER, INDEX, or REFERENCES, grant these privileges again.

Table 1. Database privileges
Database management system	Minimum privilege required
DB2®	The CONNECT and CREATETAB privileges are required on the database level. The upgrade process accesses system views and procedures. Grant the SELECT and EXECUTE privileges to this user for the upgrade. These privileges are already granted to the public group by default; it is not necessary to grant them unless they have been revoked. `syscat.tables syscat.views syscat.columns syscat.indexes PROCEDURE ADMIN_CMD`
DB2 for z/OS®	The CONNECT and CREATETAB privileges are required on the database level. The upgrade process accesses some system views. Grant the SELECT privilege to this user for the upgrade. These privileges are already granted to the public group by default; it is not necessary to grant them unless they have been revoked. `sysibm.systables sysibm.sysviews sysibm.syscolumns sysibm.sysindexes`
MSSQL	The CONNECT and CREATE TABLE privileges are required on the database level. The upgrade process accesses system tables. Grant the SELECT privilege to this user for the upgrade. This privilege is already granted to the public group by default; it is not necessary to grant it unless it has been revoked. `INFORMATION_SCHEMA.COLUMNS.TABLES INFORMATION_SCHEMA.COLUMNS.COLUMNS sys.indexes sys.sysobjects`
Oracle	The CONNECT, RESOURCE, DBA_TABLES, and SELECT privileges are required on the database level. The upgrade process accesses system views. Grant the SELECT privilege to this user for the upgrade. This privilege is already granted to the public group by default; it is not necessary to grant it unless it has been revoked. `USER_INDEXES USER_TABLES USER_TAB_COLUMNS all_objects all_constraints all_tab_columns`