Online Documentation for SQL Manager for DB2

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 group

iconDB select a database for grants management

 

Authorization group

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

 

General group

iconCompile compile changes

iconRefresh refresh the content of the window

iconRestoreDefaultSize restore the default size and position of the window

 

Objects group

Tick select database object type to grant privileges on

 

 

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 an object to the selected user/group;
  • revoke a previously granted permission;
  • grant all permissions on an object to the selected user/group;
  • revoke all previously granted permissions on an object;
  • grant all permissions (with GRANT Option) on an object to the selected user/group;
  • grant a permission on all objects to the selected user/group;
  • revoke a previously granted permission on all objects;
  • grant a permission (with GRANT Option) on all objects to the selected user/group;
  • grant all permissions on all objects to the selected user/group;
  • revoke all previously granted permissions on all objects;
  • grant all permissions (with GRANT Option) on all objects to the selected user/group.

 

Grant Manager - Using context menu