Role Mapping Usage Notes | QueryGrid - Role 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
The Teradata initiator takes the current role of the initiating user or the roll ALL if the user has multiple roles enabled.

Teradata-to-Teradata

  • Adds proxyrole=target role to QueryBand.
  • Initiates SET ROLE target role when a JDBC is statement created, saving the default role.
  • Initiates SET ROLE default role when a JDBC statement is closed.
  • For all queries, QueryBand is reset using SET QUERY_BAND=NONE FOR SESSION when a JDBC statement is closed.

Teradata-to-Presto

  • Initiates SET ROLE target role when a JDBC is statement created, saving the default role.
  • Initiates SET ROLE default role when a JDBC statement is closed.

Teradata-to-Hive

  • Initiates SET ROLE target role when a JDBC is statement created, saving the default role.
  • Initiates SET ROLE default role when a JDBC statement is closed.

Teradata-to-Spark

  • Not supported.

Teradata-to-Oracle

  • Initiates SET ROLE target role when a JDBC is statement created, saving the default role.
  • Initiates SET ROLE default role when a JDBC statement is closed.

Teradata-to-BigQuery

  • Not supported.

Teradata-to-Generic JDBC

  • Not supported.