Access Permissions needed to create Db2 external database for OM Web Viewer 12.1

Products

• Output Management Web Viewer

Issue/Introduction

What Access Permissions (SELECT, INSERT, UPDATE, DELETE, etc.) are needed to create these tables with Db2.

Environment

• IBM Db2
• Output Management Web Viewer 12.1

Resolution

Web Viewer will need an (Db2) ID with row-level SELECT/UPDATE/INSERT/DELETE permissions. It does NOT need TABLE create permissions if you pre-create the tables via the DDL.

Only if you want the product to create the tables (not the preferred method), will it need TABLE create. This ID should have a non-expiring password or else you will need to re-run the config tool each time the password is changed.