将Students表的查询权限授予用户U1和U2,并允许该用户将此权限授予其他用户。实现此功能的SQL语句是:()。
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;
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;
D
举一反三
- 将查询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
- 将查询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
- 下列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
- 【单选题】下列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;
- 若要授予用户u1在Goods表上具有查询权限,下列语句正确的是 ( ) A: GRANT ON Goods SELECT TO u1 B: GRANT TO u1 SELECT ON Goods C: GRANT SELECT ON Goods TO u1 D: GRANT SELECT TO u1 ON Goods
内容
- 0
将查询关系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;
- 1
在R1,R2的串联电路中,已知两电阻两端的电压分别为U1U2,则电路两端的总电压为() A: U=U1=U2 B: U=U1=U2 C: U=1/U1=1/U2 D: U=1/U1=1/U2
- 2
在2个电阻串联电路中,已知2个电阻的端电压分别为U1和U2,则电路两端的总电压U应为()。 A: U=U1=U2 B: U=U1+U2 C: U=1/U1+1/U2 D: U=1/U1=1/U2
- 3
利用以下第()式可以查出P(|U|>u)的值。 A: Φ(-u) B: Φ(u)-1/2 C: 2Φ(-u) D: Φ(u2)-Φ(u1)
- 4
V带传动中,U1为主动轮圆周速度,U2为从动轮圆周速度,v为带速,这些速度之间存在的关系是() A: U1=U=U2 B: U1>U>U2 C: U1<U<U2 D: U1=U>U2