Prevenet user to see Information_schema

[angelcool]

I am running MySQL 5.0.67, I want to grant all privileges to a user for a certain database, but when i run the following command, it also allows the user to access information_schema.

 

_{grant all on products.* to productsuser@'10.10.10.%' identified by 'letmein';}

 

Thiese are the grants given by the above command

 

^{mysql> show grants for  productsuser@'10.10.10.%';}

^{+------------------------------------------------------------------------------------------+}

^{| Grants for [email protected].%                                                          |}

^{+------------------------------------------------------------------------------------------+}

^{| GRANT USAGE ON *.* TO 'productsuser'@'10.10.10.%' IDENTIFIED BY PASSWORD '032c41e8435273a7' |}

^{| GRANT ALL PRIVILEGES ON `products`.* TO 'productsuser'@'10.10.10.%'                        |}

^{+------------------------------------------------------------------------------------------+}

^{2 rows in set (0.00 sec)}

 

All I want is give all edit/view  privileges to a user for the given database' tables  only.

 

Thank you.

[fenway]

By "edit", you mean update/insert/delete?  "All" is very dangerious.

[angelcool]

Perhaps only INSERT,UPDATE and DELETE.

 

...but my point is to prevent user from viewing information_schema.

 

 

When I connect with the account productsuser (using SQLYog), the GRANT command lets me view the information_chema table.

[fenway]

Well then you'll have to revoke the other privileges -- easier to revoke all, the grant only the ones you want.

[angelcool]

I will try that, only grant SELECT,INSERT,UPDATE and DELETE; I will test for viewing information_schema.

 

I will update later.