Theoretically, It is not. See 4.3.1 GRANT and REVOKE Syntax
GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY 'password']
[, user_name [IDENTIFIED BY 'password'] ...]
[WITH GRANT OPTION]
Willy
"Martin Moss"
<Martin_moss@btin To: <[EMAIL PROTECTED]>
ternet.com> cc:
Subject: mysql question
01/23/2003 09:10
AM
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
