Online Documentation for SQL Manager for SQL server

Defining endpoint permissions

This tab allows you to grant Endpoint permissions to the login.

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, VIEW DEFINITION, TAKE OWNERSHIP, CONTROL.

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 login;
• grant a permission (with Grant Option) on the endpoint to the login;
• deny a permission on the endpoint to the login;
• revoke a previously granted or denied permission;
• grant all permissions on the endpoint to the login;
• grant all permissions (with Grant Option) on the endpoint to the login;
• deny all permissions on the endpoint to the login;
• revoke all previously granted or denied permissions;
• grant a permission on all endpoints to the login;
• grant a permission (with Grant Option) on all endpoints to the login;
• deny a permission on all endpoints to the login;
• revoke a previously granted or denied permission on all endpoints