MySQL - Table Level Permissions

[cancer10]

Hi

I have a MySQL 5.x database. I have 5 tables in it. Is there anyway I can have 5 users assigned to 5 different tables in such a way that one user can have access to the DB but can ONLY view his own table and not view any other tables in that DB?


Pls suggest.


Thanks

[mic2100]

u can definetly assign users to specific databases, but ive been looking and i don't think u can assign them permissions for specific tables.

Please will someone correct me if im wrong, i wud also like to know if this is possible.

[djm0219]

Users may be given table level permissions as well as column level permissions if desired. Take look at section 5.4 of the manual (http://dev.mysql.com/doc/refman/6.0/en/privilege-system.html) for details.