The Grant Manager(GM) allows you to easily and rapidly set permissions for all database objects.
The GM is separated into 2 panes, the left being the user/group/role selection and the right the grant selection area.
First you must select a role from the list, then you just check off or uncheck permissions for displayed objects.
You may also right click on a grant for more options:
Grant/Revoke All, will grant/revoke all to the selected object.
Set Selected will set the grant for all selected objects(They must be of the same type).
NOTE: The MySQL version grant manager is slightly different, but behaves the same.
See also: