home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / MAGAZINE / MISC / DBMS9104.ZIP / SQL3.APR < prev    next >
Encoding:
Text File  |  1991-03-01  |  252 b   |  2 lines
  1.  
  2. CREATE VIEW MY_EMPLOYEES     AS SELECT * FROM EMPLOYEE        WHERE DEPARTMENT =               (SELECT DEPARTMENT FROM MANAGER_XREF                WHERE USER_NAME = USER)         WITH CHECK OPTIONGRANT ALL PRIVILEGES ON MY_EMPLOYEES TO PUBLIC