Hide the source code of a SQL UDF from users

Extensibility
Fan

Hide the source code of a SQL UDF from users

Hi,

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

Rolf

1 REPLY
Senior Apprentice

Re: Hide the source code of a SQL UDF from users

Hi Rolf,

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 :-)