View Full Version : [ubuntu] Setting privilages for mysql users

December 10th, 2008, 11:09 PM
Hi Guys

I have 3 users on my mysql server with full privilages. The problem is if I log in with any one of these accounts I am able to see ALL tables regardless of who made them. Is there any way I can change this so that users can only see the tables they have created ?

December 10th, 2008, 11:39 PM
I am not a MySQL expert but I believe it is something like this:

deny all privileges on somedb.tablename to 'someuser' identified by 'passwrd';

I usually use a GUI like phpmyadmin, somehow I think I understand what I'm doing better if I can see it.

The mysql website has pretty good documentation, you can probably find a specific answer there with some reading.

December 12th, 2008, 03:42 AM
No expert here either, but a user with GRANT privileges can GRANT or REVOKE privileges to SHOW, SELECT... to name a couple. I can't say the HELP command has provided me with much information. Privileges can be limited to databases, tables, or (maybe) fields.