UDFs | Privileges Needed for Database Administration | Teradata Vantage - User-Defined Functions (UDFs) - Analytics Database - Teradata Vantage

If you grant a user the CREATE FUNCTION privilege on a database, any function a user creates automatically has DROP FUNCTION, EXECUTE FUNCTION, and WITH GRANT OPTION on the function.

A UDF running in protected mode runs in a process created to run as the user called “tdatuser.” This user has no special operating system privileges. It is up to the site to decide what resources “tdatuser” is to have access to by setting access privileges to system resources as required by the site.

If the user has the DROP FUNCTION privilege, the SHOW FUNCTION statement also displays the C source.

To grant the user privileges to run a specific user-defined functions, submit:

GRANT EXECUTE ON SPECIFIC FUNCTION  function_name  TO  username;

To grant EXECUTE privileges on all UDFs in a database:

GRANT EXECUTE FUNCTION ON  dbname  TO  username;