Online Documentation for SQL Manager for SQL server

Defining login permissions

This tab allows you to define Login permissions to the server role.

The Login Name column contains the list of server logins; each subsequent column corresponds to the permission which can be granted on the selected login: ALTER, CONTROL, IMPERSONATE, VIEW DEFINITION.

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

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