revoke1.sql

来自「1. 熟悉数据库的安全性管理工具和命令。 2． 熟悉通过DBMS对数据库进行」· SQL 代码 · 共 12 行

REVOKE INSERT ON Student 
FROM student
CASCADE;

REVOKE DELETE ON SC  
FROM teacher
CASCADE;

REVOKE UPDATE ON Student
FROM teacher
CASCADE;