Privileges | Oracle Target Connector | Teradata QueryGrid - Oracle Target Connector Privileges - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.19
Published
July 2022
Language
English (United States)
Last Update
2022-07-28
dita:mapPath
jpf1654813554544.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

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.