Read Only MySQL Database
 

I was wondering what would be the minimum grant options to allow for read only access to a mysql database. I have a member of management :mad: who insists on using MS Access to link to our mysql database. I have built a PHP front end that give people the access that he needs but still they insist on using mysql connector and MS Access.

I can only thing that they would need SELECT access or maybe just USEAGE Access. Any help would be greatly appreciated...

:mad: Stupid Microsoft Users

I gave the user USAGE only access but that was to low. After reading on-line and finding vague description I found out that USAGE is equal to no privileges. So at that point I granted SELECT Permissions and user is able to read all entries from database. I figured this is what I needed to do but I didn't know if MS Access would dink around my permissions and kill DB. Connected MS Access to MySQL using OBDC MySQL connector.

That should be fine. Only the dba (mysql root) or the schema owner is able to change perms for other users.
Have you seen this: http://dev.mysql.com/doc/refman/5.0/en/privileges.html