grant update,select on school.stu to 'user1'@'localhost' IDENTIFIED BY '87654321'关于上面语句说法正确的是
A: 用户只能访问表school
B: 用户名叫user1，密码时87654321
C: 用户的权限是更新和查询
D: 用户只能从本地访问服务器
A: 用户只能访问表school
B: 用户名叫user1，密码时87654321
C: 用户的权限是更新和查询
D: 用户只能从本地访问服务器
举一反三
- 使用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';
- “把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是（）。 A: GRANT SELECT, UPDATE(gradON TABLE sc TO user1 B: GRANT SELECT sc, UPDATE sc, grade TO user1 C: GRANT SELECT, UPDATE ON TABLE s grade TO user1 D: GRANT SELECT ON TABLE sc, UPDATE ON TABLE sc(grad TO user1
- “把查询SC表和更新SC表的grade列的权限授予用户user”的正确SQL语句是( )。 A: GRANT SELECT sc．UPDATE sc.grade TO user B: GRANT SELECT,UPDATE(grade)ON TABLE sc TO user C: GRANT SELECT,UPDATE ON TABLE sc．grade TO user D: GRANT SELECT ON TABLE sc，UPDATE ON TABLE sc(grade)TO user
- 下面使用DROP USER语句删除用户user1的语句中,正确的是 A: DROP USER user1@localhost; B: DROP USER 'user1'.’ocalhost'; C: DROP USER user1.localhost; D: DROP USER 'user1'@'localhost';
- 用Tran-SQL语句实现权限管理时，收回用户user1对Orders表的查询权限。下列收回权限语句正确的是： 。 A: GRANT SELECT on Orders from user1 B: REVOKE SELECT on Orders from user1 C: GRANT SELECT on Orders to user1 D: REVOKE SELECT on Orders to user1