CHAPTER 6 Using Procedures and Batches

SELECT fullname (’Jane’, ’Smith’);

fullname (’Jane’,’Smith’)

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

237

Page 257
Image 257
Sybase 12.4.2 Dropping user-defined functions, Permissions to execute user-defined functions, 237, Fullname ’Jane’,’Smith’