Online Documentation for SQL Manager for SQL server

Using Navigation bar, Toolbar and context menu


The Navigation bar, Toolbar and context menu provide quick access to tools implemented in Grant Manager.

 

Grant Manager - Using Navigation bar

 

 

The Navigation bar of Grant Manager allows you to:

 

Database

iconDB select a database for grants management

 

General

iconRefresh refresh the content of the window

iconAddUser call User Editor to add a new database user

iconEditUser call User Editor to edit an existing user

iconDeleteUser delete a database user

iconAddRole call Role Editor to add a database role

iconEditRole call Role Editor to edit an existing database role

iconDeleteRole delete a database role

iconEffectivePermissions view effective permissions on the object

iconRestoreDefaultSize restore the default size and position of the window

 

Privileges for

btnGroupManager select an existing database user/role to grant privileges to

 

Legend

Tick view the legend

 

 

Items of the Navigation bar are also available on the ToolBar of Grant Manager. To enable the toolbar, open the Environment Options dialog, proceed to the Windows section there and select RadioButton Toolbar (if you need the toolbar only) or RadioButton Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.

 

 

The context menu is aimed at facilitating your work: you can perform a variety of operations using context menu items.

 

The context menu of Grant Manager allows you to:

  • grant a permission on a securable to the selected principal;
  • grant a permission (with Grant Option) on a securable to the selected principal;
  • deny a permission on a securable to the selected principal;
  • revoke a previously granted or denied permission;
  • grant all permissions on a securable to the selected principal;
  • grant all permissions (with Grant Option) on a securable to the selected principal;
  • deny all permissions on a securable to the selected principal;
  • revoke all previously granted or denied permissions on a securable;
  • grant a permission on all objects to the selected principal;
  • grant a permission (with Grant Option) on all objects to the selected principal;
  • deny a permission on all objects to the selected principal;
  • revoke a previously granted or denied permission on all objects;
  • apply sorting of objects in grid (by type);
  • apply sorting of objects in grid (by name);
  • view effective permissions on the object.

 

Grant Manager - Using context menu