将查询Student表和修改学生学号的权限授给用户U4。实现此功能的SQL语句是(
)。
A: GRANT UPDATE(Sno),SELECT
ON TABLE Student TO U4 ;
B: GRANT UPDATE,SELECT
ON TABLE Student TO U4 ;
C: GRANT SELECT ON TABLE
Student TO U4 ;
D: GRANT UPDATE ON TABLE
Student TO U4 ;
)。
A: GRANT UPDATE(Sno),SELECT
ON TABLE Student TO U4 ;
B: GRANT UPDATE,SELECT
ON TABLE Student TO U4 ;
C: GRANT SELECT ON TABLE
Student TO U4 ;
D: GRANT UPDATE ON TABLE
Student TO U4 ;
举一反三
- 将查询和修改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
- 使用SQL SERVER，假设U1-U5用户已存在，请将对教学（STC）数据库进行如下操作的SQL语句补充完整。 （5）把查询Student表和修改学生学号的权限授给用户U4。[br][/br] grant select, on Student to U4
- 授予用户Mary可以修改Student表的权限,使用的SQL语句是( )。 A: GRANT UPDATE ON<br/>Student TO Mary B: GRANT UPDATE ON<br/>Mary TO Student C: GRANT UPDATE TO<br/>Mary ON Student D: GRANT UPDATE TO<br/>Student ON Mary
- 使角色 R1 拥有 Student 表的 SELECT、UPDATE、INSERT 权限的语句是 A: GRANT SELECT, UPDATE, INSERT ON TABLE Student to R1 B: REVOKE SELECT, UPDATE, INSERT ON TABLE Student to R1 C: AUDIT SELECT, UPDATE, INSERT ON TABLE Student to R1 D: ROLE SELECT, UPDATE, INSERT ON TABLE Student to R1
- 使角色R1 减少 SELECT 权限的语句是 A: REVOKE SELECT ON TABLE Student FROM R1 B: REVOKE SELECT ON TABLE Student TO R1 C: GRANT SELECT ON TABLE Student FROM R1 D: GRANT SELECT ON TABLE Student TO R1