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 login permissions


This tab allows you to define Login permissions to the server role.

 

Server Role Editor - Defining login permissions

 

 

The Login Name column contains the list of server logins; each subsequent column corresponds to the permission which can be granted on the selected login: ALTER, CONTROL, IMPERSONATE, VIEW DEFINITION.

 

Right-click a cell to grant a specific permission on a certain login. To grant a permission on an login, you should find the object in the Login Name list and the column with the corresponding permission. The context menu of a cell allows you to:

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