授予用户Mary可以修改Student表的权限,使用的SQL语句是( )。
A: GRANT UPDATE ON
Student TO Mary
B: GRANT UPDATE ON
Mary TO Student
C: GRANT UPDATE TO
Mary ON Student
D: GRANT UPDATE TO
Student ON Mary
A: GRANT UPDATE ON
Student TO Mary
B: GRANT UPDATE ON
Mary TO Student
C: GRANT UPDATE TO
Mary ON Student
D: GRANT UPDATE TO
Student ON Mary
举一反三
- 将查询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 ;
- 将查询和修改Student表的权限授给用户U4的SQL语句是(<br/>)。 A: GRANT<br/>SELECT, UPDATE ON TABLE Student TO U4 B: REVOKE<br/>SELECT, UPDATE ON TABLE Student FROM U4 C: GRANT<br/>SELECT ON TABLE Student TO U4 D: REVOKE<br/>UPDATE ON TABLE Student FROM U4
- 收回所有用户对基本表STUDENT的UPDATE操作权限可由_____语句完成。 A: REVOKE UPDATE ON TABLE STUDENT FROM WANG B: REVOKE UPDATE ON STUDENT FROM WANG C: GRANT UPDATE ON STUDENT TO PUBLIC D: REVOKE UPDATE ON TABLE STUDENT FROM PUBLIC
- 使角色 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
- 授予user1用户修改st表中的“姓名”字段的权限,应使用的SQL语句是(<br/>) A: GRANT<br/>UPDATE(姓名)<br/>ON st TABLE TO user1 B: GRANT<br/>UPDATE(姓名)<br/>ON TABLE st TO user1 C: GRANT<br/>MODIFY(姓名)<br/>ON st TABLE TO user1 D: GRANT<br/>MODIFY(姓名)<br/>ON TABLE st TO user1