You must create a Teradata user with CREATE FUNCTION and
EXECUTE FUNCTION access rights.
Procedure
-
Login to Teradata using dbc as username and
password.
-
Create a user. You can use the following command:
CREATE user test AS password=test perm = 200000000, SPOOL = 100000000;
-
Grant the user you created at least the CREATE FUNCTION
and EXECUTE FUNCTION access rights.