I have a guy working with PHP and data from my DB, I want him to see the table etc how what fields i have but don't want to give him access to UPDATE, INSERT DELETE any rows or tables in my DB... what can i use???
Change his privilages using PHPmyAdmin
If you don't have access to phpMyAdmin, you can GRANT him nothing more than SELECT, SHOW DATABASES, and SHOW VIEW privileges.