grant1.sql

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

GRANT INSERT ON Student
TO student
WITH GRANT OPTION; 

GRANT UPDATE ON SC
TO student
WITH GRANT OPTION; 

GRANT DELETE,UPDATE ON Student
TO teacher
WITH GRANT OPTION;

GRANT DELETE,INSERT ON SC
TO teacher 
WITH GRANT OPTION;