Prerequisites

To create a UDF, you must have the CREATE privilege for the target schema or be logged in as the SUPER.SUPER user.

To drop a UDF, you must have the DROP privilege for the schema containing the function or be logged in as the SUPER.SUPER user.

To grant a privilege to a UDF, you must hold the privilege being granted WITH GRANT OPTION. You may also grant the privilege if security administrators are enabled and you are logged in as a security administrator or if security administrators are not enabled and you are logged in as the SUPER.SUPER user.

To revoke a privilege from a UDF, you must be the grantor of the privilege. You may also revoke the privilege if security administrators are enabled and you are logged in as a security administrator or if security administrators are not enabled and you are logged in as the SUPER.SUPER user.

To view the source of a UDF, you must hold the SELECT privilege on SOURCE for the function.