Required to perform high availability server administrative tasks.
The MANAGE ANY MIRROR SERVER system privilege allows a user to:
- Issue the CREATE, ALTER or DROP statement on mirrored
servers
- Change mirror server parameters
- Set options on mirror servers
- Execute the ALTER statement to change ownership of a database
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.