Connect Through Rights - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Connect Through Rights dialog enables you to grant, revoke, and display connect through privileges on trusted database users in its two tabs. Access this option by right-clicking a user in the Data Source Explorer and selecting Teradata > Grant/Revoke > Connect Through Rights.

Grant/Revoke Tab

Use this tab to select the trusted database users for which to set connect through rights.

Tabs Description
Trusted User Select the database user that you want proxy users to connect through.
Trust Only Check to grant connect through with trust-only option.
Grant Grant connect through privileges to application or permanent proxy users.
  • Application Proxy Users tab - Grant privileges to an application user (non-database defined) who is allowed to connect through the selected trusted user.
  • Permanent Proxy Users tab - Grant privileges to a permanent user (database defined) who is allowed to connect through the selected trusted user.
Revoke Revoke connect through privileges to an application or permanent proxy users.
Display Display the current connect through privileges for the selected trusted user.

SQL Preview

Use the SQL Preview tab to preview the generated SQL statements submitted when you click Grant or Revoke. The generated SQL updates whenever you move privilege items to the To be granted or To be revoked list. You can save the SQL to a project by using the Save SQL option in the SQL Preview tab.