Role Mapping Usage Notes | Teradata QueryGrid - Role Mapping Usage Notes - Teradata QueryGrid

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.