Online Documentation for SQL Manager for SQL server

Defining server permissions


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

 

Login Editor - Defining server permissions

 

 

The Permission column contains the list of server permissions that can be granted to the login: 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 login. The context menu of a cell allows you to:

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