Application Proxy Users Tab - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
poj1484765174891.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
Product Category
Teradata Tools and Utilities

The Application Proxy Users tab enables you to grant connect through privileges to application proxy users. Application proxy users are application users who are not defined in the Teradata or Aster database and who are allowed to connect through a trusted user.

The tab displays current grantable privileges based on the selected application user. You can move single or multiple privilege type(s) from the Grantable Privileges list to the To be Granted privileges list to specify which connect through privileges to grant. You must click Grant to grant the connect through privileges to the user.

  1. In Application User(s), enter user names (separated by commas) to define the application proxy users.
  2. In Roles, select up to 15 roles that the Trusted User can use when the DBS/Application users connect through.
  3. Click Add To to add the proxy user name and role to the Grantable Privileges list.
  4. In Grantable Privileges, review and then select the privileges to grant. Use the Shift and Ctrl keys to select multiple privileges.
  5. Move single or multiple privileges from the Grantable Privileges list to the To be Granted list using the directional arrows. The single arrow moves a single privilege; the double arrow moves multiple privileges.
  6. Preview the generated SQL statement in the SQL Preview tab, and if necessary, repeat previous steps to modify SQL.
  7. Click Grant to submit SQL and grant privileges listed in the To be Granted list.