17.10 - Granting CTCONTROL Privileges - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

You can use the GRANT CTCONTROL statement to provide users the privilege to set up and administer trusted sessions, for example:

GRANT CTCONTROL ON trusted_user TO database_username;
trusted_user
The user name for the middle-tier application being set up for trusted sessions.
database_username
The name of a permanent user, for example SECADMIN, who gains the privilege to administer proxy users and associated roles for the trusted user application.
The GRANT CTCONTROL statement can specify only one trusted user, but up to 25 administrator users, per statement.

For details on use of the GRANT CTCONTROL statement, see Teradata Vantage™ - SQL Data Control Language, B035-1149.