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] ;