


DROP TABLE OMALERT.OM_ALERT_TRIGGER_COLUMN CASCADE CONSTRAINTS ;
/
CREATE TABLE OMALERT.OM_ALERT_TRIGGER_COLUMN (
  TRIGGER_COLUMN_ID        NUMBER (10),
  TRIGGER_COLUMN_NAME      VARCHAR2 (30),
  TRIGGER_COLUMN_COND_SEQ  NUMBER (3),
  TRIGGER_TABLE_ID         NUMBER (10) ) ;
/

GRANT ALTER ON OMALERT.OM_ALERT_TRIGGER_COLUMN TO PUBLIC;
/

GRANT DELETE ON OMALERT.OM_ALERT_TRIGGER_COLUMN TO PUBLIC;
/

GRANT INDEX ON OMALERT.OM_ALERT_TRIGGER_COLUMN TO PUBLIC;
/

GRANT INSERT ON OMALERT.OM_ALERT_TRIGGER_COLUMN TO PUBLIC;
/

GRANT SELECT ON OMALERT.OM_ALERT_TRIGGER_COLUMN TO PUBLIC;
/

GRANT UPDATE ON OMALERT.OM_ALERT_TRIGGER_COLUMN TO PUBLIC;
/

GRANT REFERENCES ON OMALERT.OM_ALERT_TRIGGER_COLUMN TO PUBLIC;
/




CREATE PUBLIC SYNONYM OM_ALERT_TRIGGER_COLUMN FOR OMALERT.OM_ALERT_TRIGGER_COLUMN;
/
