授予用户Jean可以查询帐户表account的权限,使用的SQL语句是(
)
A: GRANT
SELECT ON account TO Jean
B: GRANT
SELECT TO Jean ON account
C: GRANT
SELECT TO account ON Jean
D: GRANT
SELECT ON Jean TO account
)
A: GRANT
SELECT ON account TO Jean
B: GRANT
SELECT TO Jean ON account
C: GRANT
SELECT TO account ON Jean
D: GRANT
SELECT ON Jean TO account
举一反三
- 将查询Student表和修改学生学号的权限授给用户U4。实现此功能的SQL语句是(<br/>)。 A: GRANT UPDATE(Sno),SELECT<br/>ON TABLE Student TO U4 ; B: GRANT UPDATE,SELECT<br/>ON TABLE Student TO U4 ; C: GRANT SELECT ON TABLE<br/>Student TO U4 ; D: GRANT UPDATE ON TABLE<br/>Student TO U4 ;
- 给名字是zhangsan的用户分配对数据库studb中的stuinfo表的查询和插入数据权限的语句是(<br/>) A: grant<br/>select,insert on studb.stuinfo<br/>for 'zhangsan'@' localhost' B: grant<br/>select,insert on studb.stuinfo<br/>to 'zhangsan'@' localhost' C: grant<br/>'zhangsan'@'localhost' to select,insert for studb.stuinfo D: grant<br/>'zhangsan'@'localhost' to studb.stuinfo<br/>on select,insert
- 将查询和修改Student表的权限授给用户U4的SQL语句是(<br/>)。 A: GRANT<br/>SELECT, UPDATE ON TABLE Student TO U4 B: REVOKE<br/>SELECT, UPDATE ON TABLE Student FROM U4 C: GRANT<br/>SELECT ON TABLE Student TO U4 D: REVOKE<br/>UPDATE ON TABLE Student FROM U4
- 将查询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可以查询帐户表的权限,使用的SQL语句是