EMS logo

Products Navigation

SQL Manager for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for MySQL

On-line Documentation

Managing global privileges


The Global privileges area of the Grant Manager window allows you to define global privileges and extended properties for MySQL users.

 

Note: This area is available for setting grants on entire databases when a host is selected in the Host or Database group of the Navigation bar (or toolbar).

 

To edit global privileges of a user, select the user in the Privileges for pane of the Navigation bar or toolbar. Tick off a checkbox to grant the global privilege to the selected user. For your convenience the CheckBox With grant option and CheckBox All privileges options are available below.

 

Use the panel below of the user Global privileges group to edit extended user properties: Max. queries per hour, Max. updates per hour, Max. connections per hour, Max. users connection. Use the spinner controls to set the required values for the properties.

 

Grant Manager - Managing global privileges

 

 


See also:

Using Navigation bar, Toolbar and context menu

Managing database-specific privileges

Managing column permissions

Filtering objects in list