no "execute procedure" rights for judf

Connectivity
Enthusiast

no "execute procedure" rights for judf

Hi

I created a very basic JUDF as described in the official tutorials:

http://developer.teradata.com/tools/articles/getting-started-with-teradata-plug-in-for-eclipse

http://developer.teradata.com/tools/articles/creating-a-simple-java-user-defined-function-using-the-...

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.

1 REPLY
Enthusiast

Re: no "execute procedure" rights for judf

I finally found a workaround in this tutorial:

http://developer.teradata.com/extensibility/articles/picture-this-teradata-and-digital-image-process...

There he creates another database where it is possible to grant rights to create UDFs.