使角色R1减少SELECT权限的语句是( )。
A: REVOKE
SELECT ON TABLE Student FROM R1
A: REVOKE
SELECT ON TABLE Student FROM 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
- 使角色 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 在原来的基础上增加 Student 表的 DELETE 权限的语句是 A: GRANT DELETE ON TABLE Student FROM R1 B: GRANT DELETE ON TABLE Student TO R1 C: REVOKE DELETE ON TABLE Student FROM R1 D: REVOKE DELETE ON TABLE Student TO R1
- 将查询和修改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
- 基于表S创建视图R的SQL语句是【 】 A: CREATE R AS SELECT 学号,姓名 FROM S B: CREATE TABLE R AS SELECT 学号,姓名 FROM S C: CREATE VIEW R AS SELECT 学号,姓名 FROM S D: CREATE R FROM SELECT 学号,姓名 AS S