mysql - 使用 "*"快速授予某些 mysql 数据库表的权限？

Question

有没有可能做这样的事情？

GRANT SELECT , INSERT , UPDATE , DELETE ON  `database`.`prefix_*` TO  'user'@'localhost';

这让我可以为每个以“prefix_”开头的表快速设置权限

Answer 1

您可以使用 % 代替 *

GRANT SELECT , INSERT , UPDATE , DELETE ON  `database`.`prefix\_%` TO  'user'@'localhost';

来自docs :

The “_” and “%” wildcards are permitted when specifying database names in GRANT statements that grant privileges at the global or database levels. This means, for example, that if you want to use a “_” character as part of a database name, you should specify it as “_” in the GRANT statement, to prevent the user from being able to access additional databases matching the wildcard pattern;