Re: mysql grant problem?
| From: | Jason Stechschulte | Date: | Mon, 26 Mar 2001 21:31:22 +0000 |
| Subject: | Re: mysql grant problem? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7852@lists.php.net to get a copy of this message | ||
On Sat, Mar 24, 2001 at 11:22:37PM +0800, Fai wrote:
> When we use grant as following:
> GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
> "peter";
>
> Then peter can only select the field of col_name_1 on the tbl_name_1 of
> db_name_1.
>
> However, when peter issue the query: DESC tbl_name_1; he can see all the
> structure of that table. This makes that peter does not know which column he
> can use.
>
> Does any body know how to make peter only can see the column which he has
> right to use it when he issue DESC tbl_name_1.
I'm not sure but I think this is a question that should have been posted
to a Mysql list.
mysql@lists.mysql.com
--
Jason Stechschulte
jpstech@unoh.edu
--
OOPS! You naughty creature! You didn't run Configure with sh!
I will attempt to remedy the situation by running sh for you...
-- Larry Wall in Configure from the perl distribution