2.06 - Oracle Target Connector Privileges - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty

When running schema discovery (Teradata-initiated help foreign) queries, the target information must be retrieved from the Oracle data dictionary views. You must have access to the views in order to successfully receive the results. When collect metrics is enabled, you must have access to the Oracle performance view, V$SQL, to collect resource utilization data. To access tables with Varray type, the user must have the SELECT_CATALOG_ROLE or SELECT ANY DICTIONARY grant to run the query if Varray is not already defined in the accessible schema.