将查询Teacher表的权限授予用户Liu,并允许该用户将此权限授予其他用户。实现此功能的SQL语句是()。
A.GrantSelectToTeacherOnLiuWithPublic
B.GrantSelectOnTeacherToLiuWithPublic
C.GrantSelectToTeacherOnLiuWithGrantOption
D.GrantSelectOnTeacherToLiuWithGrantOption
A.GrantSelectToTeacherOnLiuWithPublic
B.GrantSelectOnTeacherToLiuWithPublic
C.GrantSelectToTeacherOnLiuWithGrantOption
D.GrantSelectOnTeacherToLiuWithGrantOption
收回用户li对表employee的查询权限,同时级联收旧li授予其他用户的该权限,SQL语句为:
(52) select ON TABLE employee FROM li (53) ;
(52)
A.GRANT
B.GIVE
C.CALL BACK
D.REVOKE
● 收回用户li对表employee的查询权限,同时级联收回li授予其他用户的该权限,SQL语句为:
(52) select ON TABLE employee FROM li (53) ;
(52)
A. GRANT
B. GIVE
C. CALL BACK
D. REVOKE
(53)
A. RESTRICT
B. CASCADE
C. WITH GRANT OPTION
D. WITH CHECK OPTION
A.GRANTSELECTTOSCONU1WITHPUBLIC
B.GRANTSELECTONSCTOU1WITHPUBLIC
C.GRANTSELECTTOSCONU1WITHGRANTOPTION
D.GRANTSELECTONSCTOU1WITHGRANTOPTION
将查询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
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
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
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
对下列两个关系模式: 学生(学号,姓名,年龄,性别,家庭住址,班级号) 班级(班级号,班级名,班主任,班长) 使用GRANT语句完成下列授权功能: (1)授予用户U1对两个表的所有权限,并可给其他用户授权 (2)授予用户U2对学生表具有查看权限,对家庭住址具有更新权限 (3)将对班级表查看权限授予所有用户 (4)将对学生表的查询、更新权限授予角色R1 (5)将角色R1授予用户U1,并且U1可继续授权给其他角色
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!