|
如下语句:
> grant select on `dbname%`.`tablename%` to 'user'@'host' identified by 'passwd';
ERROR 1146 (42S02): Table 'dbname%.tablename%' doesn't exist
想知道怎么才能直接为一组表如:
db00.table0000, db00.table0001, db00.table0002...,
db01.table0032, db01.table0033, db01.table0034...,
db02.table0064, db02.table0065, db02.table0066...,
......
赋予权限而不用使用循环来达到目的?
谢谢 |
|