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;

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

Which version of phpMyAdmin are you using ?


Patrick Guillot mailto:[EMAIL PROTECTED] - +33 (0)6 08 41 11 54
Online Development - Paanjaru
Riding the Shockwave in cyberspace, for now ... and ever

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to