DELETE USER and Java External Stored Procedures - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

When you delete a user, you must also delete all Java external procedures, Java UDFs, and JAR files.

When you delete the user, the system internally performs the following actions on Java external procedure-related dictionary tables:

  1. If there are Jars defined in the current user, then the system updates the corresponding row for the current database in DBC.Dbase with an incremented JarLibRevision number.
  2. If there are Jars defined in the current user, then the system deletes all rows in DBC.Jar_Jar_Usage where the JarDatabaseId matches the ID of the user to be deleted.
  3. If there are Jars defined in the current user, then the system deletes all rows in 
DBC. Routine_Jar_Usage where the DatabaseId matches the ID of the user to be deleted.
  4. If there are Jars defined in the current user, then the system deletes all rows in DBC.Jars where the DatabaseId matches the ID of the user to be deleted.