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]