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:
- 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 BPM 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.
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_CMDDB2 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.sysindexesMSSQL 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.sysobjectsOracle 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