EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

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