Access Rights required to execute a Function

Database
Enthusiast

Access Rights required to execute a Function

Hello Experts,

I created the HASH_MD5 function from the UDF available in Teradata downloads. When I use this function, I'm getting the following error.

SELECT HASH_MD5('ABCD');

                       $

 *** Failure 3706 Syntax error: expected something between '(' and the strin g 'A' keyword.

I created this function under my user, and then I'm able to use it. However, when created in a different database, I get this error.

What access rights are required to execute this function successfully?

Regards,

VP

4 REPLIES
Enthusiast

Re: Access Rights required to execute a Function

Hi VP,

Maybe you can try   ALTER FUNCTION abcdefghi.HASH_MD5 EXECUTE NOT PROTECTED;

Please let me know.

Cheers,

Raja

Junior Contributor

Re: Access Rights required to execute a Function

This error indicates that the function was not found, it's not related to access right.

Did you qualify the function, dbname.HASH_MD5('ABCD')?

A UDF is only found when it's in SYSLIB, the current default database or fully qualified.

Enthusiast

Re: Access Rights required to execute a Function

Aha!!!!Thanks Dieter. 

Enthusiast

Re: Access Rights required to execute a Function

Thanks Dieter. That worked. I was not qualifying the function earlier.

-Vidyadutt