ASA SQL User's Guide
Using Procedures, Triggers, and Batches
Introduction to user-defined functions
Ownership of a user-defined function belongs to the user who created it, and that user can execute it without permission. The owner of a user-defined function can grant permissions to other users with the GRANT EXECUTE command.
For example, the creator of the function fullname could allow another_user to use fullname with the statement:
GRANT EXECUTE ON fullname TO another_user
The following statement revokes permissions to use the function:
REVOKE EXECUTE ON fullname FROM another_user
For more information on managing user permissions on functions, see Granting permissions on procedures.