* NIST SQL Test Suite, V4.0, Schema Definition, schema2.std !
* 59-byte ID !
* TEd Version # !
* date_time print !
* *************************************************************** !
* ****** THIS FILE SHOULD BE RUN UNDER AUTHORIZATION ID CUGINI !
* *************************************************************** !
* This is a standard schema definition. !
     CREATE SCHEMA AUTHORIZATION CUGINI !
     GRANT SELECT,UPDATE ON HU.WORKS 
           TO SULLIVAN !
      CREATE TABLE VTABLE 
            (COL1  INTEGER,
             COL2  INTEGER,
             COL3  INTEGER,
             COL4  INTEGER,
             COL5  DECIMAL(7,2)) !
     GRANT ALL PRIVILEGES ON VTABLE TO HU !
 *  Test GRANT without grant permission below -- expect error message
 *  "WITH GRANT OPTION" purposefully omitted from HU''s GRANT on STAFF4.
 *  Do not change file SCHEMA1 to allow "WITH GRANT OPTION" on STAFF4.!
     GRANT SELECT, INSERT, DELETE ON HU.STAFF4 
           TO SCHANZLE !
  CREATE TABLE AA (CHARTEST     CHAR(20)) !
  CREATE VIEW VAA AS SELECT * FROM AA !
  CREATE TABLE BB (CHARTEST     CHAR) !
  CREATE VIEW VBB AS SELECT * FROM BB !
  CREATE TABLE CC (CHARTEST     CHARACTER(20)) !
  CREATE VIEW VCC AS SELECT * FROM CC !
  CREATE TABLE DD (CHARTEST     CHARACTER) !
  CREATE VIEW VDD AS SELECT * FROM DD !
  CREATE TABLE EE (INTTEST     INTEGER) !
  CREATE TABLE FF (INTTEST     INT) !
  CREATE TABLE GG (C1 INT) !
  CREATE TABLE HH (SMALLTEST  SMALLINT) !
  CREATE TABLE II (C1 INT) !
  CREATE VIEW VII AS SELECT * FROM II !
  CREATE TABLE JJ (C1 INT) !
  CREATE TABLE SRCH1 (C1 INT) !
  CREATE TABLE BADG1 (C1 INT) !
  CREATE TABLE BADG2 (C1 INT) !
  CREATE VIEW VBADG2 AS SELECT * FROM BADG2 !
  CREATE VIEW VVTABLE AS SELECT * FROM VTABLE !
   GRANT SELECT ON AA TO SCHANZLE !
   GRANT SELECT ON VAA TO SCHANZLE !
   GRANT INSERT ON BB TO SCHANZLE !
   GRANT INSERT ON VBB TO SCHANZLE !
   GRANT UPDATE ON CC TO SCHANZLE !
   GRANT UPDATE ON VCC TO SCHANZLE !
   GRANT DELETE ON DD TO SCHANZLE !
   GRANT DELETE ON VDD TO SCHANZLE !
   GRANT SELECT ON EE TO PUBLIC !
   GRANT INSERT ON FF TO PUBLIC !
   GRANT UPDATE ON GG TO PUBLIC !
   GRANT DELETE ON HH TO PUBLIC !
   GRANT ALL PRIVILEGES ON II TO SCHANZLE !
   GRANT ALL PRIVILEGES ON VII TO SCHANZLE !
   GRANT ALL PRIVILEGES ON JJ TO PUBLIC !
   GRANT INSERT, UPDATE, DELETE ON SRCH1 TO SCHANZLE !
   GRANT ALL PRIVILEGES ON BADG1 TO FLATER !
   GRANT SELECT ON VBADG2 TO FLATER WITH GRANT OPTION !
   GRANT ALL PRIVILEGES ON VVTABLE TO HU !
 * ************* End of Schema ************* !
