CREATE/REPLACE FUNCTION SQL Statement | Teradata Vantage - CREATE FUNCTION and REPLACE FUNCTION (SQL Form) - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Creates or replaces an SQL UDF.

Required Privileges

The privileges required to perform CREATE FUNCTION and REPLACE FUNCTION (SQL Form) differ as follows:
  • You must have explicit CREATE FUNCTION privileges on the database, including SYSUDTLIB for SQL UDFs associated with UDTs, in which the function is to be contained to perform the CREATE FUNCTION request.

    The system does not grant the CREATE FUNCTION privilege automatically when you create a database or user: you must grant the privilege explicitly.

    CREATE FUNCTION is not granted implicitly on the databases and functions owned by a database or user unless the owner also has an explicit WITH GRANT OPTION privilege defined for itself.

  • You must have explicit DROP FUNCTION privileges on the function or on the database in which the function is contained to perform the REPLACE FUNCTION (SQL Form) statement on an existing function. You do not need the CREATE FUNCTION privilege to replace a function.
  • You must have explicit CREATE FUNCTION privileges on the database in which the function is to be contained to perform the REPLACE FUNCTION (SQL Form) statement to create a new function.
If a UDT is specified as an input parameter or the SQL function result, the current user must have one of the following privileges:
  • UDTUSAGE on the SYSUDTLIB database.
  • UDTUSAGE on the specified UDT.

Privileges Granted Automatically

The following privileges are granted automatically to the creator of an SQL function:
  • DROP FUNCTION
  • EXECUTE FUNCTION