View Full Version : [ubuntu] Setting privilages for mysql users
December 10th, 2008, 11:09 PM
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.
Powered by vBulletin® Version 4.2.1 Copyright © 2014 vBulletin Solutions, Inc. All rights reserved.