IBM BPM, V8.0.1, All platforms > Migrating and upgrading your IBM BPM environment > Migrating from previous versions > Migrating from IBM BPM Standard V7.5.x, Teamworks 7, or WebSphere Lombardi Edition > Migrating to IBM BPM V8.0.1

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 BPM V8.0.1.

Important:

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

: Migrating to IBM BPM V8.0.1