CA Repository Exchange for Oracle Access requirements

Document ID : KB000018501
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

What Oracle catalog objects and/or roles are required in order to successfully execute the CA Repository Exchange for Oracle?

Solution:

The following are the data dictionary views which are accessed by the CA Repository exchange for Oracle. It does not use any of the catalog tables.

 

 SYS:DBA_ALL_TABLES
 SYS:DBA_SOURCE
 SYS:DBA_TRIGGERS
 SYS:DBA_TABLESPACES
 SYS:DBA_DATA_FILES
 SYS:DBA_SEQUENCES
 SYS:DBA_VIEWS
 SYS:DBA_CLUSTERS
 SYS:DBA_TAB_COMMENTS
 SYS:DBA_PART_TABLES
 SYS:DBA_TAB_COLUMNS
 SYS:DBA_COL_COMMENTS
 SYS:DBA_SYNONYMS
 SYS:DBA_CONSTRAINTS
 SYS:DBA_INDEXES
SYS:DBA_IND_EXPRESSIONS SYS:DBA_IND_COLUMNS SYS:DBA_CONS_COLUMNS SYS:DBA_TRIGGER_COLS SYS:DBA_CLU_COLUMNS SYS:DBA_TAB_COLS

 

The Oracle user which is used to operate Oracle exchange must have following roles\privileges,

  • CONNECT role or CREATE SESSION system privilege
  • SELECT_CATALOG_ROLE role.