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.

The Navigation bar of Grant Manager allows you to:

Host or database group

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

General group

refresh the content of the window

call User Editor to add a new database user

call User Editor to edit an existing user

delete a database user

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

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

restore the default size and position of the window

Privileges for group

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:

• call User Editor to add a new user;
• call User Editor to edit the selected user;

• delete the selected user.

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 Toolbar (if you need the toolbar only) or 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.