Required to perform high availability server administrative tasks.
The MANAGE ANY MIRROR SERVER system privilege allows a user to:
- Issue 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 WITH NO ADMIN OPTION
clause is used by default.