Tool for editing MySQL table permissions?

4k Views Asked by At

Is there a tool that makes the task of editing user privileges easier on a MySQL database? I've got nearly 100 tables to work through for 4 users, each with different per-table grants, which is getting tedious via phpMyAdmin. It'll get a lot more irritating when I make changes to the database structure and user list later on. I also can't see a way to do it in MySQL Workbench.

Are there any permissions management tools that make management of table permissions easier?

Update: For clarification, I need a tool that can manage the per-schema and per-table permissions for a user. I'll be changing permissions later, so it needs to be able to fully manage existing permissions as well as grant new ones. MySQL Workbench allows management of per-schema privileges, but not per-table.

8

There are 8 best solutions below

1
On

You may want to look at www.securich.com - its an open source user management tool for MySQL.

1
On

Workbench is supposed to let you manage users and grant privileges -- see here. You can also use Navicat (not free) or if you are on a mac, Sequel Pro, which is free.

1
On

MySQL Workbench provides this functionality.

  1. Open a connection via 'Server Administration'
  2. Click on 'Users and Privileges'
  3. Select the 'Schema Privilegs' tab
  4. Create entries for the schema you're working on, per your needs.

More information here.

2
On

Mysql gui tools . See here http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL Administrator allows you to do all that.

0
On

Just looked at my install of Squirrel-SQL here. I've only got Oracle databases in this copy of it, but I use it for MySQL at home. Anyway, for Oracle, for tables, it has two tabs: Privileges, and Column Privileges. It may or may not provide similar functionality for MySQL. Give it a look perhaps. (I like it for other database work.)

0
On

I realize the question is a couple of years old but I came across it while looking for a solution so I suppose others might as well.

I came across SQL Yog and find it capable of doing all that I wanted. I use the community version so it is free to download and its User Manager has the capability to set permissions at the schema and table level.

1
On

phpMyAdmin allows table-level privileges. More details can be found, for exemple, here and here.

3
On

Try Security Manager tool in dbForge Studio for MySQL (the Security Manager is available in free Express Edition).

In new version multi-user editing is supported; you can select some users and grant or revoke Global and Object (database, tables, fields, ...) privileges, then apply changes or view them in SQL script.