Online Documentation for SQL Manager for MySQL

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:

 

Host or database group

iconDB select a host to manage global privileges or a database to manage database-specific and column permissions

 

General group

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

iconExtractUserGrants extract the selected user's grants and load the script to SQL Script Editor

iconExtractAllUsersGrants extract all users' grants and load the script to SQL Script Editor

iconRestoreDefaultSize restore the default size and position of the window

 

Privileges for group

btnGroupManager select an existing database user to grant privileges to

 

Right-click an item within the Privileges for list to call the context menu allowing you to:

 

 

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

 

Grant Manager - Using context menu