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.
Required Privileges
To alter a function definition, you must have the ALTER FUNCTION privilege on that function.
There are no privileges granted automatically.