12.1 Web Viewer - Request Web Viewer DB2 Table Privilege Required
search cancel

12.1 Web Viewer - Request Web Viewer DB2 Table Privilege Required

book

Article ID: 203767

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

12.1 Web Viewer is installed and in the Installation process we defined DB2 requirements of DB/Tables with latest  DB2DDLMF member you 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 WEB TOMCAT server.

Environment

Release : 12.1

Component : CA OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS

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