User Mapping Usage Notes | QueryGrid - User Mapping Usage Notes - 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
lifecycle
latest
Product Category
Analytical Ecosystem

Teradata-to-Teradata

  • Trusted authentication uses the mapped remote user (instead of the initiator local user) for proxyuser= in the QueryBand; JDBC connection authentication still uses the authUser.
  • When logged in as initiatorUser on the initiating database, submitting a query without a database name such as SELECT * FROM table@FS generates the query SELECT * FROM initiatorUser.table and the target connector modifies the query to use SELECT * FROM mappedRemoteUser.table on the remote.

Teradata-to-Presto

  • None authentication uses the mapped remote user (instead of the initiator local user) for user= in the JDBC URL.
  • It does not modify the query.

Teradata-to-Hive

  • Trusted Kerberos authentication uses the mapped remote user (instead of the initiator local user) for hive.server2.proxy.user= in the JDBC URL.
  • None authentication uses the mapped remote user (instead of the initiator local user) for the JDBC connection authentication.
  • It does not modify the query.

Teradata-to-Spark

  • None authentication uses the mapped remote user (instead of the initiator local user) for the JDBC connection authentication.
  • It does not modify the query.

Teradata-to-Oracle

  • OS authentication uses the mapped remote user (instead of the authUser).
  • It does not modify the query.

Teradata-to-BigQuery

  • Not supported.

Teradata-to-Generic JDBC

  • Not supported.