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

Specifying permissions


Use the Permissions tab to grant permissions to a user.

 

User Editor - Specifying permissions

 

 

The Grantee column contains the list of roles and users; each subsequent column corresponds to the permission which can be granted on the selected user: ALTER, CONTROL, VIEW DEFINITION, IMPERSONATE.

 

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

  • grant a permission to the user;
  • grant a permission (with Grant Option) to the user;
  • deny a permission to the user;
  • revoke a previously granted or denied permission;
  • grant all permissions to the user;
  • grant all permissions (with Grant Option) to the user;
  • deny all permissions to the user;
  • revoke all previously granted or denied permissions;
  • grant a permission on all users and roles to the user;
  • grant a permission (with Grant Option) on all users and roles to the user;
  • deny a permission on all users and roles to the user;
  • revoke a previously granted or denied permission on all users