Performs either or both of the following functions.
- Controls whether an existing function can run in protected mode as a separate process or in unprotected mode as part of the database.
- Recompiles C or C++ functions or relinks Java functions and redistributes them.
Java UDFs must always run in protected mode, so you cannot use this statement to change their protection mode.
Privileges
To alter a function definition, you must have the ALTER FUNCTION privilege on that function.
There are no privileges granted automatically.