ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 211826


Updated On:


ACF2 - DB2 Option


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?




Release : 16.0

Component : CA ACF2 Option for Db2


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