.


- 3


, , : (, , , ߠ , ). , , . :

CREATE VIEW AVG (, , ._., O)

AS SELECT ,,AVG (._ ),ˠ

FROM GROUP BY O

 

, (._), . SELECT - ߠ .

, ꠠ .   SQL GRANT REVOKE. :

 

GRANT SELECT ON TABLE C TO ,

 

, SELECT C.

 

GRANT SELECT, UPDATE () ON TABLE C TO

 

, SELECT C, .

 

REVOKE SELECT ON TABLE C FROM

, SELECT ѻ.

, :

SELECT ()

UPDATE ()

DELETE ()

INSERT ()

GRANT . , , , ..

 

:

GRANT SELECT ON TABLE C TO WITH GRANT OPTION

:

GRANT SELECT ON TABLE C TO WITH GRANT OPTION

GRANT OPTION, .

GRANT OPTION, :

 

REVOKE SELECT ON TABLE C FROM

, , , ..