Is there a Method to grant SELECT to ALL TABLES in ACF2/DB2 without writing seperate rules for each table
search cancel

Is there a Method to grant SELECT to ALL TABLES in ACF2/DB2 without writing seperate rules for each table

book

Article ID: 211826

calendar_today

Updated On:

Products

ACF2 - DB2 Option

Issue/Introduction

A requirement from the audit team to be able to do SELECT on ALL Db2 tables with ACF2/DB2.

Is there an easy way to grant an ID SELECT on All defined tables?

 

 

Environment

Release : 16.0

Component : CA ACF2 Option for Db2

Resolution

There is no single permission that will allow a user  select access to all db2 tables.
Separate rule for each DB2 table are required.