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

QueryGridâ„¢ Installation and User Guide - 3.08

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Teradata QueryGrid
Release Number
3.08
Published
July 2025
ft:locale
en-US
ft:lastEdition
2025-07-30
dita:mapPath
tca1747267140087.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.