All Forums Database
vidyadutt.s 6 posts Joined 09/13
03 Jan 2014
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

-Vidyadutt

Raja_KT 1246 posts Joined 07/09
03 Jan 2014

Hi VP,
Maybe you can try   ALTER FUNCTION abcdefghi.HASH_MD5 EXECUTE NOT PROTECTED;
Please let me know.
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
04 Jan 2014

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.

Dieter

Raja_KT 1246 posts Joined 07/09
04 Jan 2014

Aha!!!!Thanks Dieter. 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

vidyadutt.s 6 posts Joined 09/13
09 Jan 2014

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

-Vidyadutt

You must sign in to leave a comment.