-
Título
Required permissions to Reverse Engineer or Complete Compare against an Oracle 10g/11g/12c databa -
Descrição
Required minimal permissions to Reverse Engineer or Complete Compare against an Oracle database. -
Resolução
Description:
What are the minimum required permissions for Reverse Engineering directly or during loading a model from an Oracle database during Reverse Engineering or 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 system catalog tables:For Oracle versions 12cR2, 18c, 19c, 21c:
'CONNECT' and 'SELECT_CATALOG_ROLE'
e.g.,
GRANT CONNECT TO <USER_NAME> ;
GRANT SELECT_CATALOG_ROLE TO <USER_NAME> ;
NOTE: The list above is for the basic object and properties. In addition to the above privileges, 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 seen in the SQL Trace file which can be accessed as detailed in the following TechDoc:
https://questsoftware.lightning.force.com/lightning/r/Knowledge__kav/ka06R000000FRC5QAO/view