使用GRANT语句创建用户名为user1、密码为123，并授予该用户对chapter08.student表有查询权限。 下面选项中，能实现上述功能的语句是 A. GRANT SELECT ON chapter08.student FOR 'user1'@'localhost' IDENTIFIED BY '123'; B. GRANT USER SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123'; C. GRANT USER SELECT ON chapter08.student 'user1'@'localhost' IDENTIFIED BY '123'; D. GRANT SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123';