erwin DM Reverse Engineer: Minimum permissions required to Reverse Engineer from a SQL Server da (4289608)

Question: What Database User Permissions are Required to Reverse Engineer from SQL server database?

 

Solution: Users need to have the SELECT (read/write) privileges for the objects and metadata tables being reverse engineered.

sys.check_constraints
sys.column_encryption_keys
sys.columns
sys.computed_columns
sys.default_constraints
sys.extended_properties
sys.foreign_key_columns
sys.foreign_keys
sys.identity_columns
sys.index_columns
sys.indexes
sys.key_constraints
sys.masked_columns
sys.objects
* sys.partition_schemes
* sys.partitions
sys.sql_modules
sys.table_types
sys.tables

*Note: You will need access to these only if partitions are selected.

 

Should any data not be returned, you can check the SQL Trace file which captures the queries sent to the database to retrieve the data from the database.  To check the missing data, look for the query trying to retrieve that property value and make sure you have Select access to the Table referred to in the FROM clause.  The process to activate and create the SQL Trace file is detailed in a document that you can access from the URL below:

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