Required to perform server-operator-related 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 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 WITH NO ADMIN OPTION
clause is used by default.