Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 257 / 536

CHAPTER 6 Using Procedures and Batches
237
SELECT fullname (’Jane’, ’Smith’);
The
fullname
function can be used by any user who has been granted
EXECUTE permission for the function.
Dropping user-defined functions
Once a user-defined function is created, it remains in the database until it is
explicitly removed. Only the owner of the function or a user with DBA
authority can drop a function from the database.
The following statement removes the function
fullname
from the database:
DROP FUNCTION fullname
Permissions to execute user-defined functions
A user-defined function is owned by the user who created it, and that user can
execute it without permission. Permission to execute it can be granted to other
users using 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 permission 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” on page 361
fullname (’Jane’,’Smith’)
Jane Smith