select concat(‘grant all on ‘, table_schema,".",table_name," to ‘ gxsnerp‘@‘localhost ‘;") from tables where table_schema=‘gxsnerp‘ and table_name like ‘ACT%‘;
生成拼接语句如下：
grant all on gxsnerp.ACT_HI_VARINST` to ‘gxsnerp‘@‘localhost‘;
grant all on gxsnerp.ACT_GE_PROPERTY to ‘gxsnerp‘@‘localhost‘;
grant all on gxsnerp.ACT_ID_MEMBERSHIP to ‘gxsnerp‘@‘localhost‘ ;
grant all on gxsnerp.ACT_HI_ACTINST to ‘gxsnerp‘@‘localhost‘ ;
原文：http://blog.51cto.com/13504089/2058994