收回用户Jean对帐户表的插入权限,使用的SQL语句是()
A.GRANT SELECT ON 帐户 TO Jean
B.REVOKE SELECT ON 帐户 FROM Jean
C.DENY SELECT ON 帐户 TO Jean
D.REVOKE SELECT ON 帐户 TO Jean
A.GRANT SELECT ON 帐户 TO Jean
B.REVOKE SELECT ON 帐户 FROM Jean
C.DENY SELECT ON 帐户 TO Jean
D.REVOKE SELECT ON 帐户 TO Jean
A GRANT SELECT ON 帐户 TO Jean
B GRANT SELECT TO Jean ON 帐户
C GRANT SELECT TO帐户 ON Jean
D GRANT SELECT ON Jean TO 帐户
A.GRANTSELECTON帐户TOJean
B.GRANTUPDATEONJeanFROM帐户
C.GRANTINSERT帐户ONJean
D.GRANTCREATETABLETOJean
● 将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
A.GRANT SELECT ON 账户 TO July
B.GRANT SELECT TO July on 账户
C.GRANT SELECT TO 账户 ON Jean
D.GRANT SELECT ON July TO 账户
能够实现“收回用户U4对学生表(STUD)中学号(XH)的修改权”的SQL语句是______。
● 撤销 U5 对 Emp 表的查询权限,并收回 U5 授予其它用户的该权限,SQL 语句是 (51) 。
(51)
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;
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!