Grant the ability to execute a user-defined function by granting the EXECUTE object-level privilege.
You must be the owner of the user-defined function, or have EXECUTE privilege with administrative rights on the function.
Ownership of a user-defined function belongs to the user who created it, and no privilege is required for that user to execute it.
Context and remarks
You have created a function and you want other user to be able to use it.
Connect to the database.
Execute a GRANT EXECUTE statement similar to the following:
GRANT EXECUTE ON function-name TO user-id;
For example, the creator of the Nationality function could allow another user to use Nationality with the statement:
GRANT EXECUTE ON Nationality TO BobS;
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|