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
举一反三
- 将查询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
- 将查询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
- 【单选题】下列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;
- 将Students表的查询权限授予用户U1和U2，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是：（）。 A: GRANT SELECT TO TABLE Students ON U1,U2 WITH PUBLIC; B: GRANT SELECT ON TABLE Students TO U1,U2 WITH PUBLIC; C: GRANT SELECT TO TABLE Students ON U1,U2 WITH GRANT OPTION; D: GRANT SELECT ON TABLE Students TO U1,U2 WITH GRANT OPTION;
- 若要授予用户u1在Goods表上具有查询权限，下列语句正确的是 ( ) A: GRANT ON Goods SELECT TO u1 B: GRANT TO u1 SELECT ON Goods C: GRANT SELECT ON Goods TO u1 D: GRANT SELECT TO u1 ON Goods
内容
- 0
将查询关系S的权限授予用户WANG，并允许该用户将此权限授予给其他用户，实现此功能的SQL语句是（ ）。 A: GRANT SELECT TO S ON WANG WITH PUBLIC; B: GRANT SELECT ON S TO WANG WITH PUBLIC; C: GRANT SELECT TO S ON WANG WITH GRANT OPTION; D: GRANT SELECT ON S TO WANG WITH GRANT OPTION;
- 1
“把查询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
- 2
“把查询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
- 3
把对S表查询权限、插入记录权限授权给U1，正确的SQL语句是（）。 A: Grant SelectinsertonStoU1 B: Grant Select,insertonStoU1 C: Grant Update(姓名)onStoU1with grant option D: Grant Update(姓名)onStoU1
- 4
将查询SC表的权限授予用户U1，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是