Re: phpmyadmin user grants
| From: | Patrick Guillot | Date: | Wed, 19 Dec 2001 21:32:44 +0000 |
| Subject: | Re: phpmyadmin user grants | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15121@lists.php.net to get a copy of this message | ||
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:pguillot@paanjaru.com - +33 (0)6
08 41 11 54
Online Development - Paanjaru http://www.paanjaru.com
Riding the Shockwave in cyberspace, for now ... and ever