MS SQL Maestro online Help
Server Roles
Fixed server roles can be mapped to the more granular permissions:
| 1. | bulkadmin. Granted: ADMINISTER BULK OPERATIONS. |
| 2. | dbcreator. Granted: CREATE DATABASE. |
| 3. | diskadmin. Granted: ALTER RESOURCES. |
| 4. | processadmin. Granted: ALTER SERVER STATE, ALTER ANY CONNECTION. |
| 5. | securityadmin. Granted: ALTER ANY LOGIN. |
| 6. | serveradmin. Granted: ALTER SETTINGS, SHUTDOWN, CREATE ENDPOINT, ALTER SERVER STATE, ALTER ANY ENDPOINT, ALTER RESOURCES. |
| 7. | setupadmin. Granted: ALTER ANY LINKED SERVER. |
| 8. | sysadmin. Granted with GRANT option: CONTROL SERVER. |
Note: Fixed server roles are server-wide in their scope. Each member of a fixed server role can add other logins within the role.
Server roles are edited within Server Roles Editor. In order to run the editor you should either
| • | select the server role for editing in the explorer tree (type the first letters of the server role name for quick search); |
| • | select the Edit Server Role item from the popup menu |
or
| • | open the server in Server Editor and the Server Roles tab there; |
| • | select the server role to edit; |
| • | press the Enter key or select the Edit Server Role item from the popup menu (alternatively, you can use the corresponding link of the Navigation Bar). |
See also: Logins
Customers
