要授予用户读取表中数据的权限，应使用哪个命令？
A: ALLOW SELECT
B: GRANT SELECT
C: LET READ
D: PERMIT READ
A: ALLOW SELECT
B: GRANT SELECT
C: LET READ
D: PERMIT READ
举一反三
- 要授予用户读取表中数据的权限,应使用哪个命令?[br][/br] [br][/br](2.0) A: ALLOW SELECT B: GRANT SELECT C: LET READ D: PERMIT READ
- 从游标中读取数据，使用什么命令 A: select B: fecth C: select from D: read
- 要授予所有用户对表 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;
- 将查询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
- 授予用户Jean可以查询帐户表account的权限,使用的SQL语句是(<br/>) A: GRANT<br/>SELECT ON account TO Jean B: GRANT<br/>SELECT TO Jean ON account C: GRANT<br/>SELECT TO account ON Jean D: GRANT<br/>SELECT ON Jean TO account