Privileges | Oracle Target Connector | Teradata Fabric - Oracle Target Connector Privileges - Teradata Fabric

Teradata® Fabric - Installation and User Guide - 3.11

Product
Teradata Fabric
Release Number
3.11
Published
August 2026
ft:locale
en-US
ft:lastEdition
2026-08-15
dita:mapPath
svw1780362788070.ditamap
dita:ditavalPath
ezw1784752870623.ditaval
dita:id
lxg1591800469257

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.