网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
请用SQL的GRANT和REVOKE语句(加上视图机制)完成以下授权定义或存取控制功能
参考答案
更多 “请用SQL的GRANT和REVOKE语句(加上视图机制)完成以下授权定义或存取控制功能” 相关考题
考题
● 撤销 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;
考题
20 ) 下列 SQL 语句中 , 能够实现 “ 收回用户 WANG 对学生表 ( STUDENT ) 中学号 ( XH ) 的修改权 ” 这一功能的是A ) GRANT UPDATE ( XH ) ON STUDENT TO WANGB ) GRANT UPDATE ( XH ) ON TABLE TO WANGC ) REVOKE UPDATE ( XH ) ON STUDENT FROM WANGD ) REVOKE UPDATE ( XH ) ON TABLE TO WANG
考题
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A. Alice onlyB. Alice and ReenaC. Alice, Reena, and TimberD. Sue, Alice, Reena, and Timber
考题
下列SQL语句中,能够实现“收回用户WANG对学生表(STUDENT)中学号(XH)的修改权”这一功能的是( )。A.GRANT UPDATE(XH) ON STUDENT TO WANGB.GRANT UPDATE(XH) ON TABLE TO WANGC.REVOKE UPDATE(XH) ON STUDENT FROM WANGD.REVOKE UPDATE(XH) ON TABLE FROM WANG
考题
单选题The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()A
Alice onlyB
Alice and ReenaC
Alice, Reena, and TimberD
Sue, Alice, Reena, and Timber
考题
单选题创建角色可以()。A
使用GRANT语句B
使用REVOKE语句C
使用ALTER语句D
使用CREATE语句
热门标签
最新试卷