Online Documentation for SQL Manager for SQL server

Specifying permissions

Use the Permissions tab to grant permissions to a user.

The Grantee column contains the list of roles and users; each subsequent column corresponds to the permission which can be granted on the selected user: ALTER, CONTROL, VIEW DEFINITION, IMPERSONATE.

Right-click a cell to grant a specific permission on a certain user or role. To grant a permission on a user, you should find the object in the Grantee list and the column with the corresponding permission. The context menu of a cell allows you to:

• grant a permission to the user;
• grant a permission (with Grant Option) to the user;
• deny a permission to the user;
• revoke a previously granted or denied permission;
• grant all permissions to the user;
• grant all permissions (with Grant Option) to the user;
• deny all permissions to the user;
• revoke all previously granted or denied permissions;
• grant a permission on all users and roles to the user;
• grant a permission (with Grant Option) on all users and roles to the user;
• deny a permission on all users and roles to the user;
• revoke a previously granted or denied permission on all users