SQL-Server-Level Roles

Fixed Server-Level Roles

The following table shows the fixed server-level roles and their capabilities.

Permissions of Fixed Server Roles

Each fixed server role has certain permissions assigned to it. The following graphic shows the permissions assigned to the server roles.

Server-Level Permissions

Only server-level permissions can be added to user-defined server roles. To list the server-level permissions, execute the following statement. The server-level permissions are:

SELECT * FROM sys.fn_builtin_permissions('SERVER') ORDER BY permission_name;  

Working with Server-Level Roles

The following table explains the commands, views, and functions that you can use to work with server-level roles.