Once users create a User Defined Function, they can provide other users with access to use that function. To provide a user with access to a User Defined Function created by you, use the following syntax:

GRANT EXECUTE ON [owner_name]udf_name TO { username [, username ] , ...| PUBLIC }
[ WITH GRANT OPTION]
;