6(1)
GRANT ALL PRIVILEGES
ON 学生,班级
TO U1
WITH GRANT OPTION;
6.(2)
GRANT SELECT,UPDATE(家庭住址)
ON Student
TO U2;
6.(3)
GRANT SELECT
ON 班级
TO PUBLIC;
6.(4)
GRANT SELECT,UPDATE
ON 学生
TO R1;
6.(5)
GRANT R1
TO U1
WITH ADMIN OPTION;
7.(1)
GRANT SELECT
ON 职工,部门
TO 王明;
7.(2)
GRANT INSERT,DELETE
ON 职工,部门
TO 李勇;
7.(3)
GRANT SELECT
ON 职工
WHEN USER()=NAME
TO ALL;
7.(4)
GRANT SELECT,UPDATE(工资)
ON 职工
TO 刘星;
7.(5)
GRANT ALTER
ON 职工,部门
TO 张新;
7.(6)
GRANT ALL PRIVILEGES
ON 职工,部门
TO 周平
WITH GRANT OPTION;
7.(7)
CREATE VIEW S_Wedges
AS
SELECT 部门.部门号,名称,MAX(工资),MIN(工资),AVG(工资)
FROM 职工,部门
WHERE 职工.部门号=部门.部门号;
GRANT SELECT
ON VIEW S_Wedges
TO 杨兰;
8.(1)
REVOKE SELECT
ON 职工,部门
FROM 王明;
8.(2)
REVOKE DELETE,INSERT
ON 职工,部门
FROM 李勇;
8.(3)
REVOKE SELECT
ON 职工
WHEN USER()=NAME
TO ALL;
8.(4)
REVOKE SELECT,UPDATE(工资)
ON 职工
TO 刘星;
8.(5)
REVOKE ALTER
ON 职工,部门
FROM 张新;
8.(6)
REVOKE ALL PRIVILEGES
ON 职工,部门
TO 周平 CASCADE;
8.(7)
REVOKE SELECT
ON S_Wedge
FROM 杨兰;