16.00 - Connect Through Rights - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

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.