Question:
What Database User Permissions are Required to Reverse Engineer from Teradata?
Solution:
Users need to have the SELECT (read/write) privileges for the objects and metadata tables being reverse engineered. In addition, execute permissions on Procedure/Functions and Cursors for the following list of Teradata catalogue tables are needed....
DBC.Databases
DBC.Columns
DBC.IdCol
DBC.UDTCast
DBC.dbcinfo
DBC.Tables
DBC.ErrorTblsV
DBC.Triggers
DBC.Table_LevelConstraints
DBC.ColumnStats
DBC.ColumnStats
DBC.Indices
DBC.AllRights
DBC.TVM
DBC.All_RI_Children
DBC.Authorizations
DBC.RoleMembers
DBC.RoleInfo
DBC.ProfileInfo
DBC.RepTables
DBC.RepGroup
DBC.AccountInfo
DBC.RepCaptureRulesV
Please note that the System Catalog Tables as mentioned above are for Teradata v. 14. Later versions of the database may have more Tables, Columns and properties. 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:
