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;
Regards
David Logan
Database Administrator
HP Managed Services
139 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Rajashik Kar [mailto:[EMAIL PROTECTED]
Sent: Thursday, 2 September 2004 2:21 PM
To: '[EMAIL PROTECTED] '
Subject: how to create a user with limited privileges
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 help.
thanks,
-rajashik
Confidentiality Notice
The information contained in this electronic message and any attachments
to this message are intended
for the exclusive use of the addressee(s) and may contain confidential
or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[EMAIL PROTECTED] immediately
and destroy all copies of this message and any attachments.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]