DROP FUNCTION Privilege - Analytics Database - Teradata Vantage

SQL Data Control Language

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
sgu1628111251052.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dvv1472243528022
lifecycle
latest
Product Category
Teradata Vantageā„¢

You must specify DROP FUNCTION to grant that privilege on a database object. If you are granting the privilege on a particular UDF only, then you can specify DROP without also specifying the FUNCTION keyword.

When creators have WITH GRANT OPTION on a function, they can grant the following privileges to another user on that function:
  • DROP FUNCTION
  • EXECUTE FUNCTION

Users with the DROP FUNCTION privilege on a function can also replace that function. If a user drops the function, however, the user cannot replace the function at a later time without also being granted the CREATE FUNCTION privilege.