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

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty
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.