【C400117】在“mysql>”数据库操作环境中,执行( )语句可以授权jerry用户对auth库中的所有表具有查询权限。
A.GRANT SELECT ON auth.* TO jerry IDENTIFIED BY '1234';
B.GRANT SELECT ON auth.* TO jerry@'%' IDENTIFIED BY '1234';
C.GRANT QUERY ON auth.* TO jerry IDENTIFIED BY '1234';
D.GRANT QUERY ON auth.* TO jerry@'%' IDENTIFIED BY '1234';