16.20 - Required Privileges - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)
Privileges needed for creating and debugging UDFS:
  • CREATE FUNCTION
  • EXECUTE FUNCTION
Privileges needed for creating and debugging external stored procedures:
  • CREATE EXTERNAL PROCEDURE
  • EXECUTE PROCEDURE
Privileges needed for debugging UDFs or external stored procedures by a user other than the one who created the routines:
  • EXECUTE FUNCTION or EXECUTE PROCEDURE
  • DROP FUNCTION or DROP PROCEDURE
Privileges needed for creating and debugging UDMs:
  • ALL on SYSUDTLIB
For example, the following statement grants all privileges on SYSUDTLIB to the user named debugger:
grant all on sysudtlib to debugger with grant option;