Hello:
I was wondering if anyone had any advice to a couple questions.
1) Can I add additional columns to the user and db tables of mysql. These would be for administrative purposes only.
You can, but doing so is unsupported, and the server won't do anything with them. You also introduce the possibility of conflict with changes made the the grant tables in future releases.
2) I'm trying to figure out how the privileges effect the system. I understand what each one does, but haven't found a clear explanation of what the difference is in the db table and the user table. If any one can explain this I would appreciate it.
user = global privileges db = db-specific privileges
3) I'm looking to come up with the most secure set of privileges for the user and db tables. I want the users to be able to select, insert, delete, create tables, just the basic functions on their database only. Multiple databases are hosted on the same mysql server.
Don't grant them privileges in the user table, because those are global. Grant them on a database-specific level.
Thank you for your help in these questions.
Mike Walth CinoFusion
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
