Online Documentation for SQL Manager for SQL server

Defining endpoint permissions


This tab allows you to grant Endpoint permissions to the server role.

 

Server Role Editor - Defining endpoint permissions

 

 

The Endpoint Name column contains the list of server endpoints; each subsequent column corresponds to the permission which can be granted on the selected endpoint: ALTER, CONNECT, CONTROL, TAKE OWNERSHIP, VIEW DEFINITION.

 

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

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