Online Documentation for SQL Manager for SQL server

Defining login permissions

This tab allows you to define Login permissions to the login.

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