Hey there!

Hoping someone can help me out when it comes to granting privileges for a
user in MySQL.

Basically, I have granted privileges to a user who I do not want to have
root access and I want to minimize his access to only his databases.

Using the MySQL manual, I granted him basic privileges for just such.

However, he is asking for privileges to be able to use CHECK, ANALYZE, and
REPAIR table.  He has privileges for OPTIMIZE.

So I'm not sure how to grant him these privileges, or whether that would
open a big security whole in MySQL if I did.  I've checked the manual, but
it is rather unspecific about these things.  In fact, I couldn't find what
References_priv represented privileges for either, so maybe that is it?

Thanks for any and all help!

-Mike
[EMAIL PROTECTED]



---------------------------------------------------------------------
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

Reply via email to