Sinisa Milivojevic writes: > >ALTERing will completely break security and permission systems and >will even prevent MySQL from proper functioning. >
Can you give me an example? I'm having no problems with security even after adding these columns. Users only have access to the dbs and tables that I assign in mysql.db and mysql.tables_priv, since all users are initially created with only "usage" privileges. How does adding non-privilege, information only columns to the end of mysql.user jeopardize security? >And you can only access them via GRANT / REVOKE command. I don't understand this statement. I can access them via GRANT/REVOKE, or also by directly updating the information using UPDATE, INSERT, and DELETE (with the subsequent FLUSH PRIVILEGES). --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
