16.10 - Granting CTCONTROL Privileges - Teradata Database

Teradata Database Security Administration

Product
Teradata Database
Release Number
16.10
Release Date
June 2017
Content Type
Administration
Security
Publication ID
B035-1100-161K
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  ;

where:

  • trusted_user is the Teradata Database user name for the middle-tier application being set up for trusted sessions.
  • database_username is the name of a permanent Teradata Database 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 SQL Data Control Language.