Filter
Top Products
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