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
- 将查询SC表的权限授予用户U1,并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。 A: GRANT SELECT TO TABLE SC ON U1 WITH PUBLIC B: GRANT SELECT ON TABLE SC TO U1 WITH PUBLIC C: GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTION D: GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION
- 使用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: GRANTSELECT,UPDATE(grade)ONTABLEscTOuser1 B: GRANTSELECTsc,UPDATEsc,gradeTOuser1 C: GRANTSELECT,UPDATEONTABLEs D: gradeTOuser1 E: GRANTSELECTONTABLEsc,UPDATEONTABLEsc(grade)TOuser1
- 授予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
内容
- 0
下面SQL命令的作用是( )。GRANT UPDATE(grade) ON SC TO U4WITH GRANT OPTION A: 把对表SC的grade列的UPDATE权限授予U4用户 B: 把对表SC的grade列的UPDATE权限授予U4用户,并允许他再将此权限授予其他用户 C: 把对表SC的UPDATE权限授予U4用户
- 1
将查询SC表的权限授予用户U1,并允许该用户将此权限授予其他用户。实现该功能的 SQL语句是______。 A: A) GRANT SELECT TO SC U1 WITH PUBLIC B: B) GRANT SELECT ON SC TO U1 WITH PUBLIC C: C) GRANT SELECT TO SC ON U1 WITH GRANT OPTION D: D) GRANT SELECT ON SC TO U1 WITH GRANT OPTION
- 2
下列SQL语句中,能够实现“将查询SC表的权限授予用户U1,并允许该用户将此权限授予其他用户”这一功能的是( ) A: GRANT SELECT TO SC ON U1 WITH PUBLIC B: GRANT SELECT ON SC TO U1 WITH PUBLIC C: GRANT SELECT TO SC ON U1 WITH GRANT OPTION D: GRANT SELECT ON SC TO U1 WITH GRANT OPTION
- 3
【单选题】下列SQL语句中,能够实现“将查询SC表的权限授予用户U1,并且允许该用户将此权限授予其他用户”这一功能的是()。 A. GRANT SELECT TO SC ON U1 WITH PBULIC; B. GRANT SELECT ON SC TO U1 WITH PUBLIC; C. GRANT SELECT TO SC ON U1 WITH GRANT OPTION; D. GRANT SELECT ON SC TO U1 WITH GRANT OPTION;
- 4
将查询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 ;