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 user name for the middle-tier application being set up for trusted sessions.
- database_username is 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.