举一反三
- grant
- 下列（）语句可以指定用户将自己所拥有的权限授予其他的用户。 A: pass grant opion B: with grant opion C: get grant opion D: set grant opion
- 数据库中SAILORS表是由joe创建的.在DBMS完成下面的语句后Grant select on Sailors To Art With Grant option...Joe执行Grant select,update on Sailors To Bob With Grant option...Joe执行Grant select on Sailors To Bob With Grant option...Art执行Revoke select on Sailors From Art Cascade...Joe执行Bob对Sailors表拥有[1分]
- 将查询关系S的权限授予用户WANG，并允许该用户将此权限授予给其他用户，实现此功能的SQL语句是（ ）。 A: GRANT SELECT TO S ON WANG WITH PUBLIC; B: GRANT SELECT ON S TO WANG WITH PUBLIC; C: GRANT SELECT TO S ON WANG WITH GRANT OPTION; D: GRANT SELECT ON S TO WANG WITH GRANT OPTION;
- grant对应
内容
- 0
要授予所有用户对表 CUSTOMER 的 SELECT 权限,需用哪个语句? A: GRANT SELECT ON CUSTOMER TO ALL USERS; B: GRANT ALL ON CUSTOMER TO ALL; C: GRANT SELECT ON CUSTOMER TO ALL; D: GRANT SELECT ON CUSTOMER TO PUBLIC;
- 1
将查询SC表的权限授予用户U1，并允许该用户将此权限授予其他用户。实现该功能的 SQL语句是______。 A: A) GRANT SELECT TO SC U1 WITH PUBLIC B: B) GRANT SELECT ON SC TO U1 WITH PUBLIC C: C) GRANT SELECT TO SC ON U1 WITH GRANT OPTION D: D) GRANT SELECT ON SC TO U1 WITH GRANT OPTION
- 2
下列SQL语句中,能够实现“将查询SC表的权限授予用户U1,并允许该用户将此权限授予其他用户”这一功能的是( ) A: GRANT SELECT TO SC ON 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
- 3
【单选题】下列SQL语句中，能够实现“将查询SC表的权限授予用户U1，并且允许该用户将此权限授予其他用户”这一功能的是()。 A. GRANT SELECT TO SC ON U1 WITH PBULIC; 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;
- 4
将查询SC表的权限授予用户U1，并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。 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