Online Documentation for SQL Manager for SQL server

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