把查询SC表的权限授予用户U1,并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是___

题目

把查询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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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

第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题:

将查询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

第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

第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


D

第7题:

将查询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


正确答案:D

第8题:

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

A、GRANTSELECTTOSCONU1WITHPUBLIC

B、GRANTSELECTONSCTOU1WITHPUBLIC

C、GRANTSELECTTOSCONU1WITHGRANTOPTION

D、GRANTSELECTONSCTOU1WITHGRANTOPTION


参考答案:D

第9题:

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

A.GRANT SELECT TO SC 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


正确答案:D
解析:选项A、B没有WITH GRANT OPTION子句,不能将权限授予其他用户;选项C是错误的表达,表名前应该用ON,用户名前用TO。