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.
Contexte et remarques
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;
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|