第四章课后习题

第四章课后习题

FRANT ALL PRIVIEGES
ON TABLE STUDENT,CLASS
TO U1
WITH GRANT OPTION;

GRANT SELECT ,UPDATE(JIATINGZHUZHI)
ON TABLE STUDENT
TO U2 ;

GRANT  SELECT
ON CLASS 
TO PUBLIC;

GRANT SELECT UPDATE 
ON STUDENT 
TO R1;

GRANT R1 
TO U1
WITH ADMIN OPTION;

GRANT R1 
TO U1
WITH ANMON OPTION;

GRANT SELECT 
ON ZHIGONG,BUMEN
TO WANGMING

GRANT SELEC,DELETE
ON ZHIGONG,BUMEN
TO LIYONG

GRANT SELECT
ON TABLE Staff
WHEN USER()=Sname
TO ALL;

GRANT SELECT ,UPDATE(GONGZI)
ON TABLE ZHIGONG
TO LIEXING;

GRANT ALTER
ON TABLE ZHIGONG,GONGZI
TO ZHANGXIN;

GRANT SELECT ,INSERT,SELETE ,UPDATE
ON TABLE ZHIGONG,BUMEN
TO ZHOUPING;
WITH GRANT OPTION

CREATE VIEW BUMENGONGZI
AS SELECT BUMEN.NAME,MAX(GONGZI),MIN(GONGZIO),AVG(GOGNZI)
FROM ZHIGONG,BUMEN
WHERE ZHIGONG.BUMENHAO=BUMEN.BUMENHAO
GROUP BY ZHIGONG.BUMENHAO;
GRANT SELECT ON TABLE BUMENGONGZI
TO YANGLAN;

REVOKE SELECT 
ON TABLE ZHIGONG,BUMEN
FROM WANGMING;

REVOKE INSERT,DELETE 
ON TABLE ZHIGONG,BUMEN
FROM LIYONG;

REVOKE SELECT 
ON TABLE ZHIGONG
WHEN USER()=SNAME
FROM ALL;

REVOKE SELECT,UPDATE 
ON TABLE ZHIGONG
FROM LIUXING;

REVOKE ALTER
ON TABLE ZHIGONG,BUMEN
FROM ZHANGXIN;

REVOKE  SELECT ,INSERT,SELETE ,UPDATE
ON TABLE ZHIGONG,BUMEN
FROM ZHOUPING

REVOKE SELECT
ON VIEW BUMENGONGZI
FROM YANGLAN
DROP VIEW BUMENGONGZI;