16.20 - Corresponding Tables and Privileges - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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