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.

 

Login Editor - Definig 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