grant1.sql

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

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;