17.00 - Corresponding Tables and Privileges - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

UDF information is stored in:

  • DBC.TVM
  • DBC.UDFInfo (stores attributes)
  • DBC.TVFIelds
  • DBC.AccLogRuleTbl
  • DBC.DBase
  • DBC.AccessRights

The privileges relating to UDFs are:

  • ALTER FUNCTION
  • CREATE FUNCTION
  • DROP FUNCTION
  • EXECUTE FUNCTION