A grant statement only works on one table at a time. You can link statements together though, such as
Grant SELECT ON table to jsmith; Grant SELECT ON table2 to jsmith; They are separate statements can be put together in one file and run together. -- Joe -----Original Message----- From: Martin Moss [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 9:10 AM To: [EMAIL PROTECTED] Subject: mysql question slightly off topic, but is it possible to grant permissions to a user on multiple tables in one sql statement in mysql? >From mysql.com:- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP -> ON bankaccount.* -> TO custom@localhost -> IDENTIFIED BY 'stupid'; can I do this ON bankaccount.*,user.*,customer.* Marty --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003
