Online Documentation for SQL Manager for MySQL

Grant Manager

Grant Manager allows you to set the user access grants for certain databases and database objects: tables, views, functions, etc.

'Global' user privileges define the user access rights to all the database tables on the server. Granting privileges on the selected databases, tables or fields allows user to perform the defined operation (select, update, insert) over all the tables of the selected database, over the selected tables or over the selected fields only.

To open Grant Manager, select the Tools | Grant Manager main menu item.

• Using Navigation bar, Toolbar and context menu
• Managing global privileges
• Managing database-specific privileges
• Managing column permissions
• Filtering objects in list