DELETE USER and Java External Stored Procedures - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
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.