Online Documentation for SQL Manager for SQL server

Defining server permissions


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

 

Server Role Editor - Setting server permissions

 

 

The Permission column contains the list of server permissions that can be granted to the server role: CONNECT SQL, SHUTDOWN, CREATE ANY DATABASE, CREATE ENDPOINT, ALTER ANY LOGIN, ALTER ANY CREDENTIAL, ALTER ANY LINKED SERVER, ALTER ANY CONNECTION, etc.

 

Right-click a cell within the State column to grant a permission to the server role. The context menu of a cell allows you to:

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