SQL SERVER 2005 - Fixed Server Roles

Fixed server role Server-level permission

1.       bulkadmin

Members of the bulkadmin fixed server role can run the BULK INSERT statement.

2.       dbcreator

Members of the dbcreator fixed server role can create databases, and can alter and restore their own databases.

3.       diskadmin

The diskadmin fixed server role is used for managing disk files.

4.       processadmin

Members of the processadmin fixed server role can terminate processes that are running in an instance of SQL Server.

5.       securityadmin

Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY, and REVOKE server-level permissions. They can also GRANT, DENY, and REVOKE database-level permissions. Additionally, they can reset passwords for SQL Server logins.

6.       serveradmin

Members of the serveradmin fixed server role can change server-wide configuration options and shut down the server.

7.       setupadmin

Members of the setupadmin fixed server role can add and remove linked servers, and also execute some system stored procedures.

8.       sysadmin

Members of the sysadmin fixed server role can perform any activity in the server. By default, all members of the Windows BUILTIN\Administrators group, the local administrator's group, are members of the sysadmin fixed server role.