I would like to define a SQL UDF that others can use, but without them being able to see the source code of the function. The documentation says that if a user has ANY privileges on a UDF (i.e. execution privileges), he or she has also the rights for SHOW FUNCTION. I there a way to take away those rights? Or do I have to define the UDF as a Java UDF if I do not want to expose the details of the implemented function.
Thanks for your help
afaik there's no way to hide the source of a SQL UDF (only SPs supports the NO SPL option).
And if it was possible, one could simply use it in a WHERE-condition and then Explain reveals the source code :-)