Category : Files from Magazines
Archive   : DBMS9104.ZIP
Filename : SQL3.APR

 
Output of file : SQL3.APR contained in archive : DBMS9104.ZIP


CREATE VIEW MY_EMPLOYEES
AS SELECT * FROM EMPLOYEE
WHERE DEPARTMENT =
(SELECT DEPARTMENT FROM MANAGER_XREF
WHERE USER_NAME = USER)
WITH CHECK OPTION
GRANT ALL PRIVILEGES ON MY_EMPLOYEES TO PUBLIC