数据库作业第四章课后习题

6，

GRANT ALL PRIVILEGES
ON TABLE Class，Student
TO U1
WITH GRANT OPTION；

GRANT SELECT UPDATE（State）
ON TABLE Student
TO U2；

GRANT SELECT
ON TABLE Student
TO PUBLIC

GRANT SELECT，UPDATE
ON TABLE Student
TO R1；

GRANT R1
TO U1
WITH GRANT OPTION

7

GRANT SELECT
FROM TABLE Worker,Department/*Worker是员工，Department是部门*/
TO 王明;

GRANT INSERT,DELETE
FROM  TABLE Worker,Department
TO 李勇;

CREATE VIEW S_Worker
AS
SELECT *
FROM TABLE Worker
WHERE Nname="李勇";/*Nname是职工名字*/

GRANT SELECT
ON S_Worker
TO 李勇;

GRANT SELECT,UPDATE(pay)/*pay是工资*/
ON Worker
TO 刘星;

GRANT ALTER 
ON Worker,Department
TO 张新;

GRANT SELECT,DELETE,UPDATE,INSERT
ON Worker,Department
TO 周平;

CREATE VIEW T_PAY(HIGH,LOW,AVG)
AS
SELECT MAX(Pay),MIN(Pay),AVG(Pay)
FROM Worker;

GRANT SELECT
ON T_PAY
TO 杨兰;

8

REVOKE SELECT
ON TABLE Worker,Department
FROM 王明;

REVOKE INSERT,DELETE
ON TABLE Worker,Department
FROM 李勇;

REVOKE SELECT
ON S_Worker
FROM 李勇;

REVOKE SELECT,UPDATE(Pay)
ON Worker
FROM 刘星;

REVOKE ALTER
ON Worker,Department
FROM 张新;

REVOKE SELECT,DELETE,UPDATE,INSERT
ON Worker,Department
FROM 周平;

REVOKE SELECT
ON T_PAY
FROM 杨兰;