Online Documentation for SQL Manager for MySQL

Manage privileges

To define grants on database objects:

• select the Tools | Grant Manager main menu item, or use the corresponding toolbar button to open Grant Manager;
• select the object type using the drop-down list on the toolbar;
• select a user from the Privileges for pane of the Navigation bar;
• edit user privileges using Grant Manager.

To define grants on tables, you can also:

• right-click a table in DB Explorer and select the Grants for Table <table_name> item from the context menu;
• edit user privileges using Grant Manager.