To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.
Permissions to extract metadata
Ensure that you have access and permissions for the Teradata database user account that you use to connect to the Teradata database.
The following table lists the schema objects and system tables on which you configure SELECT permissions for the Teradata database user account:
Schema Objects
System Tables
- Tables
- Views
- Functions
- Database
- select on dbc.COLUMNSV
- select on dbc.TABLESV
- select on dbc.DATABASESV
- select on dbc.TABLETEXTV
- select on dbc.INDICESV
- select on dbc.ALL_RI_CHILDRENV
You need permission on System tables to execute the help macro on the database for offline catalog purposes only.
Permissions to run data profiles
Ensure that you have the required permissions to run profiles.
Grant the SELECT permission to read data from the Teradata database.
Permissions to run data classification
You can perform data classification with the permissions required on the source system to perform metadata extraction.
Permissions to perform glossary association
You can perform glossary association with the permissions required on the source system to perform metadata extraction.