Required to alter a database.
The ALTER DATABASE system privilege allows a user to:
- Perform a database upgrade
- Perform cost model calibration
- Load statistics
- Change transaction logs (also requires the SERVER OPERATOR
system privilege)
- Change ownership of the database (also requires the MANAGE
ANY MIRROR SERVER system privilege)
Grant this system privilege using the WITH ADMIN OPTION, WITH NO
ADMIN OPTION, or WITH ADMIN ONLY OPTION clause. If you do not specify a clause, the
default is WITH NO ADMIN OPTION.