All Forums Connectivity
terausr123 9 posts Joined 04/12
05 May 2012
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- 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.

terausr123 9 posts Joined 04/12
06 May 2012

I finally found a workaround in this tutorial:

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

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

You must sign in to leave a comment.