revoke1.sql

1. 熟悉数据库的安全性管理工具和命令。 2． 熟悉通过DBMS对数据库进行日常简单维护操作。

REVOKE INSERT ON Student 
FROM student
CASCADE;

REVOKE DELETE ON SC  
FROM teacher
CASCADE;

REVOKE UPDATE ON Student
FROM teacher
CASCADE;