dear jtjohnston , > I have a user xyz. > I want xyz to able to see table ccl.main_table > I go to user xyz's grants > I select the database ccl > I select the table main_table > what do I grant him so he can see but not change or harm ccl.main_table
You could probably use the queries below : REVOKE ALL PRIVILEGES ON ccl.main_table FROM xyz@localhost; GRANT SELECT ON ccl.main_table TO xyz@localhost; FLUSH PRIVILEGES; You can also specify rights for some columns only, as in GRANT SELECT( col1, col3 ) ON ccl_main_table TO xyz@localhost; where a col2 shall not be seen during SELECTs. More informations on http://www.mysql.com/doc/G/R/GRANT.html Which version of phpMyAdmin are you using ? Patrick -- Patrick Guillot mailto:[EMAIL PROTECTED] - +33 (0)6 08 41 11 54 Online Development - Paanjaru http://www.paanjaru.com Riding the Shockwave in cyberspace, for now ... and ever -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]