Required Privileges - Advanced SQL Engine - Teradata Database

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;