Online Documentation for SQL Manager for SQL server

Defining server role permissions

This tab is available in SQL Server 2012 only. It allows to define Server role permissions.

The Server Role Name column contains the list of server roles; each subsequent column corresponds to the permission which can be granted on the selected server role: ALTER, CONTROL, TAKE OWNERSHIP, VIEW DEFINITION.

Right-click a cell to grant a specific permission on a certain server role. To grant a permission on a server role, you should find the object in the Server role name list and the column with the corresponding permission. The context menu of a cell allows you to:

• grant a permission on the server role to the login;
• grant a permission (with Grant Option) on the server role to the login;
• deny a permission on the server role to the login;
• revoke a previously granted or denied permission;
• grant all permissions on the server role to the login;
• grant all permissions (with Grant Option) on the server role to the login;
• deny all permissions on the server role to the login;
• revoke all previously granted or denied permissions;
• grant a permission on all server role to the login;
• grant a permission (with Grant Option) on all server role to the login;
• deny a permission on all server role to the login;
• revoke a previously granted or denied permission on all server role