使角色 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
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
举一反三
- 使角色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减少SELECT权限的语句是( )。 A: REVOKE<br/>SELECT ON TABLE Student FROM R1
- 删除student表所有的记录，下列语句正确的是 A: DELETE FROM TABLE student; B: DELETE TABLE student; C: TRUNCATE TABLE student; D: TRUNCATE FROM TABLE student;
- 删除数据表Student中的数据，应该使用（）。 A: Drop Table Student B: Delete from Student C: Delete table D: Drop Student