Contents Index Dropping user-defined functions Introduction to triggers

ASA SQL User's Guide
  Using Procedures, Triggers, and Batches
    Introduction to user-defined functions

Permissions to execute 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.


Contents Index Dropping user-defined functions Introduction to triggers