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:
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:
Comments
0 comments
Please sign in to leave a comment.