Required permissions to Reverse Engineer or Complete Compare against an Oracle 10g/11g/12c database?

Description:

What are the required permissions for Reverse Engineering directly or during loading a model from an Oracle DB (10g / 11g / 12c) database during Complete Compare?

Solution:

During Reverse Engineering, erwin DM retrieves the information from the database by querying the system catalog tables which store the objects and their properties as selected in the Option Set. So, the privileges depend on the selection in the Option Set. Users need to have the SELECT privilege on the needed tables. However, for most common purposes, the following is a list of Oracle 10g/11g/12c system catalog tables:

V$ASM_DISKGROUP
V$TABLESPACE
V$DATAFILE
V$LOG
V$LOGFILE
V$TEMPFILE
V$ROLLSTAT
SYS.DBA_DATA_FILES
SYS.DBA_TEMP_FILES
DBA_TABLESPACES
DBA_ROLLBACK_SEGS
ALL_DB_LINKS
ALL_LIBRARIES
ALL_SYNONYMS
ALL_CLUSTERS
ALL_SEQUENCES
ALL_TRIGGER_COLS
ALL_DIRECTORIES
ALL_TABLES
ALL_EXTERNAL_TABLES
ALL_PART_TABLES
ALL_TAB_COLUMNS
ALL_COL_COMMENTS
ALL_TAB_COMMENTS
ALL_CONSTRAINTS
ALL_IND_COLUMNS
ALL_IND_EXPRESSIONS
ALL_CONS_COLUMNS
ALL_TAB_COLUMNS
ALL_LOG_GROUPS

NOTE: In addition to the above privileges, the user must have the SELECT privilege on every system catalog table which stores the objects / properties as selected in the Option Set during Reverse Engineering or Complete Compare. Those system catalog tables can be see in the SQL Trace file which can be accessed as detailed in the following TechDoc:

https://support.erwin.com/hc/en-us/articles/360020985611-How-to-Enable-SQL-Trace-Logging-for-Reverse-Engineer-

Articles in this section

Comments

Articles in this section

Related articles