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
- Confirm the remote proxy user exists.
- On the remote Teradata Database system, log on as Administrator. For example, log on as user dbc.
-
Create a unique proxy user name for each system:
CREATE USER proxyuser AS PERM = 0 PASSWORD = password;
-
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.