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

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.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.