I created the HASH_MD5 function from the UDF available in Teradata downloads. When I use this function, I'm getting the following error.
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.