15.00 - SQL Procedures and Proxy Connections - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

SQL Procedures and Proxy Connections

The following rules apply to procedures created in a proxy connection.

  • The immediate owner of the procedure is the creator of all permanent objects created through the procedure.
  • During procedure execution, Teradata Database checks the privileges of the immediate owner of the procedure for all statements specified and all objects referenced in the procedure body.
  • The CONNECT THROUGH privilege for SET QUERY_BAND with a PROXYUSER in a procedure is validated against the trusted user when the procedure is executed.