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

Java UDF information is stored in:

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

The privileges relating to Java UDFs are the following:

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