给xiaowang的用户分配对数据库course 中的student表的查询、更新和插入数据权限的语句是_______。
A: grant select,update,insert on course.student for ‘xiaowang@localhost’;
B: grant select,update,insert on course.student to ‘xiaowang@localhost’;
C: grant ‘xiaowang@localhost’ to select,update,insert for course.student;
D: grant ‘xiaowang@localhost’ to course.student on select,update,insert;
A: grant select,update,insert on course.student for ‘xiaowang@localhost’;
B: grant select,update,insert on course.student to ‘xiaowang@localhost’;
C: grant ‘xiaowang@localhost’ to select,update,insert for course.student;
D: grant ‘xiaowang@localhost’ to course.student on select,update,insert;
举一反三
- 使角色 R1 拥有 Student 表的 SELECT、UPDATE、INSERT 权限的语句是 A: GRANT SELECT, UPDATE, INSERT ON TABLE Student to R1 B: REVOKE SELECT, UPDATE, INSERT ON TABLE Student to R1 C: AUDIT SELECT, UPDATE, INSERT ON TABLE Student to R1 D: ROLE SELECT, UPDATE, INSERT ON TABLE Student to R1
- 给名字是zhangsan的用户分配对数据库studb中的stuinfo表的查询和插入数据权限的语句是(<br/>) A: grant<br/>select,insert on studb.stuinfo<br/>for 'zhangsan'@' localhost' B: grant<br/>select,insert on studb.stuinfo<br/>to 'zhangsan'@' localhost' C: grant<br/>'zhangsan'@'localhost' to select,insert for studb.stuinfo D: grant<br/>'zhangsan'@'localhost' to studb.stuinfo<br/>on select,insert
- 给xiaowang的用户分配对数据库course 中的student表的查询、更新和插入数据权限的语句是_______。
- 使用SQL SERVER，假设U1-U5用户已存在，请将对教学（STC）数据库进行如下操作的SQL语句补充完整。 （3）把对Student表和Course表的增、删、改、查权限授予用户U2和U3。[br][/br] grant insert,delete,update,select on to U2,U3 grant insert,delete,update,select on Course to
- 将查询Student表和修改学生学号的权限授给用户U4。实现此功能的SQL语句是(<br/>)。 A: GRANT UPDATE(Sno),SELECT<br/>ON TABLE Student TO U4 ; B: GRANT UPDATE,SELECT<br/>ON TABLE Student TO U4 ; C: GRANT SELECT ON TABLE<br/>Student TO U4 ; D: GRANT UPDATE ON TABLE<br/>Student TO U4 ;