What Db2 Table Privilege is Required fo OM Web Viewer

Products

• Output Management Web Viewer

Issue/Introduction

OM Web Viewer is installed and in the Installation process we defined Db2 requirements of DB/Tables with latest DB2DDLMF member provided. It created 19 Tables.

In our testing environment we allowed "GRANT ALL" access to PUBLIC for all 19 tables.

What would be the appropriate GRANT ACCESS for Functional USERID accessing these Db2 Tables?

We currently have

"GRANT ALL ON TABLE XXXX.ttttbbbb                   TO YYYYY; " to all tables

where XXXX is Schema, ttttbbbb are 19 Table Names, and YYYYY is Functional ID we are employing and used in USS configuration accessing Db2 Table from Apache Tomcat® server.

Environment

• Output Management Web Viewer 12.1
• Apache Tomcat®
• IBM Db2

Resolution

Broadcom recommends not altering the provided schema, but you'll need:
DELETE
INSERT
SELECT
UPDATE

Additional Information

10/13/2023 Removed link to IBM content no longer available Nancy Lipp

CR24-NL