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 
  3.     AS SELECT * FROM EMPLOYEE
  4.         WHERE DEPARTMENT = 
  5.               (SELECT DEPARTMENT FROM MANAGER_XREF
  6.                 WHERE USER_NAME = USER)
  7.          WITH CHECK OPTION
  8. GRANT ALL PRIVILEGES ON MY_EMPLOYEES TO PUBLIC
  9.