2.10 - Setting Up the Proxy User for a Teradata-to-Teradata Connector when Authentication Mechanism is Set to Trusted - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
The proxy user:
  • Usually has no perm space or permissions beyond acting as proxy
  • Might require SPOOL and TEMPORARY space based the specific query workload of all users of the target server
  1. Confirm the remote proxy user exists.
  2. On the remote Teradata Database system, log on as Administrator. For example, log on as user dbc.
  3. Create a unique proxy user name for each system:
    CREATE USER proxyuser AS PERM = 0 PASSWORD = password;
  4. Grant proxy user CONNECT privileges for all users to be impersonated:
    GRANT CONNECT THROUGH proxyuser TO PERMANENT target_end_user without role;

    The target_end_user is the user who has access to objects from the local system. The target_end_user should be created with PERM > 0.