收回用户li对表employee的查询权限,同时级联收旧li授予其他用户的该权限,SQL语句为:
(52) select ON TABLE employee FROM li (53) ;
(52)
A.GRANT
B.GIVE
C.CALL BACK
D.REVOKE
第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
第2题:
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
第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
第4题:
撤销U5对Emp表的查询权限,并收回U5授予其他用户的该权限,SQL语句是 () 。
A.REVOKE SELECT ON TABLE Emp FROM U5 CASCADE
B.REVOKE SELECT ON TABLE Emp FROM U5 RESTRICT
C.REVOKE QUERY ON TABLE Emp FROM U5 CASCADE
D.GRANT SELECT ON TABLE Emp TO U5 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