home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / MAGAZINE / MISC / DBMS9104.ZIP / SQL2.APR < prev    next >
Encoding:
Text File  |  1991-03-01  |  188 b   |  2 lines
  1.  
  2. CREATE VIEW ACCOUNTING_EMPLOYEES 
  3.     AS SELECT * FROM EMPLOYEE
  4.         WHERE DEPARTMENT = 'ACCOUNTING'
  5.          WITH CHECK OPTION
  6. GRANT ALL PRIVILEGES ON ACCOUNTING_EMPLOYEES TO BROWN
  7.