授予用户July 可以查看账户表的权限,使用的SQL语句是()
A.GRANT SELECT ON 账户 TO July
B.GRANT SELECT TO July on 账户
C.GRANT SELECT TO 账户 ON Jean
D.GRANT SELECT ON July TO 账户
A.GRANT SELECT ON 账户 TO July
B.GRANT SELECT TO July on 账户
C.GRANT SELECT TO 账户 ON Jean
D.GRANT SELECT ON July TO 账户
将查询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.GRANTSELECTTOSCONU1WITHPUBLIC
B.GRANTSELECTONSCTOU1WITHPUBLIC
C.GRANTSELECTTOSCONU1WITHGRANTOPTION
D.GRANTSELECTONSCTOU1WITHGRANTOPTION
A.GrantSelectToTeacherOnLiuWithPublic
B.GrantSelectOnTeacherToLiuWithPublic
C.GrantSelectToTeacherOnLiuWithGrantOption
D.GrantSelectOnTeacherToLiuWithGrantOption
● 将Students表的插入权限赋予用户UserA,并允许其将该权限授予他人,应使用的SQL语句为:
GRANT (15)TABLE Students TO UserA (16) ;
(15)
A.UPDATE
B.UPDATE ON
C.INSERT
D.INSERT ON
(16)
A.FOR ALL
B.PUBLIC
C.WITH CHECK OPTION
D.WITH GRANT OPTION
●将Students表的插入权限赋予用户UserA,并允许其将该权限授予他人,应使用的SQL语句为:
GRANT(51) TABLE Students TO UserA (52) ;
(51)
A.UPDATE
B.UPDATEON
C.INSERT
D.INSERT ON
(52)
A.FORALL
B.PUBLIC
C. WITH CHECK OPTION
D.WITH GRANT OPTION
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!