DB2 UDB for Windows and Linux CDD Import Security Requirements

During CONNX import procedures, your user ID requires read-only (SELECT) access to the following system metadata views:

SYSCAT.INDEXES

SYSCAT.PACKAGES

SYSCAT.PROCEDURES

SYSCAT.PROCPARMS

SYSCAT.TABLES

To retrieve column descriptor information for tables and views, your user ID must be authorized to issue a DYNAMIC PREPARE of the following SQL statement:

SELECT * from schema.table

where schema.table is the table/view you are importing into the CDD.