I created a very basic JUDF as described in the official tutorials:
http://developer.teradata.com/tools/articles/creating- a-simple-java-user-defined-function-using-the- teradata-plug-in-for-eclipse
When I click on "Deploy" in the "JAR Files" tab in eclipse the jar file is not deployed but an error occurs:
"The user does not have EXECUTE PROCEDURE access to SQLJ.INSTALL_JAR"
I use the Teradata Express VMMachine; eclipse EE runs under Windows 7 32 Bit.
In eclipse I connect to the database by using the user "dbc".
I created the judf in the dbc-schema.
Can anybody help me? I have unfortunately no idea how to grant the correct privileges to dbc.
Thank you in advance.
I finally found a workaround in this tutorial:
There he creates another database where it is possible to grant rights to create UDFs.