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 WITH NO ADMIN OPTION
clause is used by default.