Required to perform server-operator tasks.
The SERVER OPERATOR system privilege allows a user to:
- Create databases
- Cache management
- Drop databases
- Start or stop a database
- Start or stop a database engine
- Create, alter, or drop a server
- Create encrypted or decrypted databases
- Create encrypted or decrypted files
- Issue ALTER statement to change
transaction logs on a database
- Issue RESTORE DATABASE statement for a
full database restore or to restore the catalog only
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.