将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 Stud

题目

将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

相似考题

1.将查询SC表的权限授予用户U1，并允许该用户将此权限授予其他用户。实现该功能的 SQL语句是______。A．GRANT SELECT TO SC U1 WITH PUBLICB．GRANT SELECT ON SC TO U1 WITH PUBLICC．GRANT SELECT TO SC ON U1 WITH GRANT OPTIOND．GRANT SELECT ON SC TO U1 WITH GRANT OPTION

2.将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;

3.将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是A．GRANT SELECT TO SC ON Wang WITH PUBLICB．GRANT SELECT ON SC TO Wang WITH PUBLICC．GRANT SELECT TO SC ON Wang WITH GRANT OPTIOND．GRANT SELECT ON SC TO Wang WITH GRANT OPTION

4.将查询SC表的权限授予用户U1，并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。A．GRANT SELECT TO TABLE SC ON U1 WITH PUBLICB．GRANT SELECT ON TABLE SC TO U1 WITH PUBLICC．GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTIOND．GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION

参考答案和解析
正确答案：D
更多“将Students表的查询权限授予用户U1和U2,并允许该用户将此权限授予其他用户。实现此功能的SQL语句 ”相关问题

  • 第1题：

    将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是（）

    A．GRANT SELECT TO SC ON Wang WITH PUBLIC

    B．GRANT SELECT ON SC TO Wang WITH PUBLIC

    C．GRANT SELECT TO SC ON Wang WITH GRANT OPTION

    D．GRANT SELECT ON SC TO Wang WITH GRANT OPTION


    D

  • 第2题：

    将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是——

    A．GRANT SELECT TO SC ON Wang WITH PUBLIC

    B．GRANT SELECT ON SC TO Wang WITH PUBLIC

    C．GRANT SELECT TO SC ON Wang WITH GRANT OPTION

    D．GRANT SELECT ON SC TO Wang WITH GRANT OPTION


    D

  • 第3题：

    6、将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是——

    A．GRANT SELECT TO SC ON Wang WITH PUBLIC

    B．GRANT SELECT ON SC TO Wang WITH PUBLIC

    C．GRANT SELECT TO SC ON Wang WITH GRANT OPTION

    D．GRANT SELECT ON SC TO Wang WITH GRANT OPTION


    GRANT SELECT ON SC TO Wang WITH GRANT OPTION

  • 第4题：

    6、将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是

    A．GRANT SELECT TO SC ON Wang WITH PUBLIC

    B．GRANT SELECT ON SC TO Wang WITH PUBLIC

    C．GRANT SELECT TO SC ON Wang WITH GRANT OPTION

    D．GRANT SELECT ON SC TO Wang WITH GRANT OPTION


    GRANT SELECT ON SC TO Wang WITH GRANT OPTION

  • 第5题：

    将查询SC表的权限授予用户Wang，并允许该用户将此权限授予其他用户。实现此功能的SQL语句是（）。

    A．GRANT SELECT TO SC ON Wang WITH PUBLIC

    B．GRANT SELECT ON SC TO Wang WITH PUBLIC

    C．GRANT SELECT TO SC ON Wang WITH GRANT OPTION

    D．GRANT SELECT ON SC TO Wang WITH GRANT OPTION


    D

相关内容