Repository Exchange for Oracle Access requirements

Products

• Repository

Issue/Introduction

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

 

•  

Environment

Release:  7.2
Repository-Webstation Option

Resolution

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.