Grant Manager

Database Workbench comes with a visual Grant Manager - an easy way to create, edit and delete SQL grants.

Grants overview

You can easily get lost in the different options to grant rights to users. Database Workbench has three different views on your grants so you can keep an clear view on who is able to do what. Point and click - and, of course, click the 'save' button and your grants are set.

Click for larger image
Granting a template to multiple users/roles
Extract Grant statements

You can use the Grant Manager to extract your SQL GRANT statements to a script so that you can easily take your grants to another site and run your script there.

Grant Templates

Grant templates make this Grant Manager unique. You can save the current settings for a user and apply them to one or multiple other users. This makes it very easy (and fast) to add a new user with the same old grants.