数据库作业12：第四章：数据库安全性 习题

(1)

GRANT ALL PRIVILEGES
ON Student,Class   //T-SQL一次只能授权一个表
TO U1
WITH GRANT OPTION;

(2)

GRANT UPDATE(address),SELECT
ON Student
TO U2;

(3)

GRANT SELECT 
ON CLASS
TO PUBLIC

(4)

GRANT UPDATE,SELECT
ON Student