![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
使用 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';