Hi all,
I would like to know the mysql command to do the following:
Create a user (who will access mysql database), with privilaeges so
that, he can only retrieve the information in the data base (values in
the tables), he should not be able to alter, update, delete any table
values.
Kindly
Hi Rajashik,
This is documented very well in the manual at
http://dev.mysql.com/doc/mysql/en/GRANT.html#IDX1697 You would want the
GRANT statement and only allow them SELECT privileges on the tables you
wish them to view.
eg. GRANT SELECT on test.* to user@somehost.% IDENTIFIED BY
password;