15.00 - SQL Procedures and Proxy Connections - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

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.