What Database User Permissions are Required to Reverse Engineer from Teradata?
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....
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: