DROP TABLE ppsnepl.epl_ddi_severity;

CREATE TABLE ppsnepl.epl_ddi_severity
(
   epl_id              NUMBER (30, 0) NOT NULL
  ,name                VARCHAR2 (50) NOT NULL
  ,created_by          VARCHAR2 (50) NOT NULL
  ,created_dtm         TIMESTAMP (6) NOT NULL
  ,last_modified_by    VARCHAR2 (50)
  ,last_modified_dtm   TIMESTAMP (6)
);
--TABLESPACE ppsnepl_data;

CREATE UNIQUE INDEX ppsnepl.epl_ddi_severity_pk
   ON ppsnepl.epl_ddi_severity (epl_id);
--   TABLESPACE ppsnepl_data;

ALTER TABLE ppsnepl.epl_ddi_severity ADD (
  CONSTRAINT epl_ddi_severity_pk
  PRIMARY KEY
  (epl_id)
  USING INDEX ppsnepl.epl_ddi_severity_pk
  ENABLE VALIDATE);

GRANT SELECT ON ppsnepl.epl_ddi_severity TO ppsnepl_read_only_role;