Online Documentation for SQL Manager for SQL server

Defining server role permissions


This tab allows to define Server role permissions to the current server role.

 

Server Role Editor - Defining 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 current server role;
  • grant a permission (with Grant Option) on the server role to the current server role;
  • deny a permission on the server role to the current server role;
  • revoke a previously granted or denied permission;
  • grant all permissions on the server role to the current server role;
  • grant all permissions (with Grant Option) on the server role to the current server role;
  • deny all permissions on the server role to the current server role;
  • revoke all previously granted or denied permissions;
  • grant a permission on all server role to the current server role;
  • grant a permission (with Grant Option) on all server role to the current server role;
  • deny a permission on all server role to the current server role;
  • revoke a previously granted or denied permission on all server role.