CREATE TABLE ORAMON.OMON_TOOLPRIV_HDR (
  HDR_TOOLPRIV_NUM NUMBER NOT NULL,
  APPLTOOL_ID VARCHAR2(128) NOT NULL,
  APPLTOOL_NAME VARCHAR2(128) NULL,
  APPLTOOL_DESC VARCHAR2(255) NULL,
  APPLTOOL_FLAG VARCHAR2(1) NOT NULL,
  ORACLE_SID VARCHAR2(128) NULL,
  DEF_RECORD_FLAG VARCHAR2(1) NOT NULL,
  EFFECT_DATETIME DATE NULL,
  TERM_DATETIME DATE NULL,
  INSERT_DATETIME DATE NULL,
  INSERT_USER_ID VARCHAR2(128) NULL,
  UPDATE_DATETIME DATE NULL,
  UPDATE_USER_ID VARCHAR2(128) NULL
) TABLESPACE ORAMON;

ALTER TABLE ORAMON.OMON_TOOLPRIV_HDR
 ADD CONSTRAINT OMON_TOOLPRIV_HDR_U01 PRIMARY KEY (HDR_TOOLPRIV_NUM) USING INDEX
 STORAGE(INITIAL 1M NEXT 1M PCTINCREASE 0 MAXEXTENTS 200) TABLESPACE ORAMON;

CREATE INDEX ORAMON.OMON_TOOLPRIV_HDR_N01
 ON ORAMON.OMON_TOOLPRIV_HDR(APPLTOOL_FLAG)
 TABLESPACE ORAMON
 STORAGE(INITIAL 1M NEXT 1M PCTINCREASE 0 MAXEXTENTS 200);

INSERT INTO ORAMON.OMON_TOOLPRIV_HDR
 VALUES (1000, 'bg-process', 'Background Process', NULL, 'A', NULL, 'N', TRUNC(SYSDATE), NULL, SYSDATE, 'OPS$DBA_ADMIN', SYSDATE, 'OPS$DBA_ADMIN');

INSERT INTO ORAMON.OMON_TOOLPRIV_HDR
 VALUES (1001, 'oracle.exe', 'Oracle Environment', NULL, 'A', NULL, 'N', TRUNC(SYSDATE), NULL, SYSDATE, 'OPS$DBA_ADMIN', SYSDATE, 'OPS$DBA_ADMIN');

INSERT INTO ORAMON.OMON_TOOLPRIV_HDR
 VALUES (1002, 'dbsnmp.exe', 'DBSMP Process', NULL, 'A', NULL, 'N', TRUNC(SYSDATE), NULL, SYSDATE, 'OPS$DBA_ADMIN', SYSDATE, 'OPS$DBA_ADMIN');

INSERT INTO ORAMON.OMON_TOOLPRIV_HDR
 VALUES (1003, 'resrcmon.exe', 'Oracle Failsafe Process', NULL, 'A', NULL, 'N', TRUNC(SYSDATE), NULL, SYSDATE, 'OPS$DBA_ADMIN', SYSDATE, 'OPS$DBA_ADMIN');

INSERT INTO ORAMON.OMON_TOOLPRIV_HDR
 VALUES (1050, 'sqlplus.exe', 'SQL*PLUS', NULL, 'C', NULL, 'Y', TRUNC(SYSDATE), NULL, SYSDATE, 'OPS$DBA_ADMIN', SYSDATE, 'OPS$DBA_ADMIN');

COMMIT;


CREATE TABLE ORAMON.OMON_TOOLPRIV_DTL (
 DTL_TOOLPRIV_NUM NUMBER NOT NULL,
 HDR_TOOLPRIV_NUM NUMBER NOT NULL,
 OSACCT_ID VARCHAR2(128) NOT NULL,
 OSACCT_NAME VARCHAR2(128) NULL,
 OSACCT_ROLE_ID VARCHAR2(128) NULL,
 DBUSER_NAME VARCHAR2(128) NULL,
 TERMINAL_ID VARCHAR2(128) NULL,
 DEF_RECORD_FLAG VARCHAR2(1) NOT NULL,
 EFFECT_DATETIME DATE NULL,
 TERM_DATETIME DATE NULL,
 INSERT_DATETIME DATE NULL,
 INSERT_USER_ID VARCHAR2(128) NULL,
 UPDATE_DATETIME DATE NULL,
 UPDATE_USER_ID VARCHAR2(128) NULL
) TABLESPACE ORAMON;

ALTER TABLE ORAMON.OMON_TOOLPRIV_DTL
 ADD CONSTRAINT OMON_TOOLPRIV_DTL_U01 PRIMARY KEY (DTL_TOOLPRIV_NUM, HDR_TOOLPRIV_NUM) USING INDEX
 STORAGE(INITIAL 1M NEXT 1M PCTINCREASE 0 MAXEXTENTS 200) TABLESPACE ORAMON;

CREATE INDEX ORAMON.OMON_TOOLPRIV_DTL_N01
 ON ORAMON.OMON_TOOLPRIV_DTL(OSACCT_ID)
 TABLESPACE ORAMON
 STORAGE(INITIAL 1M NEXT 1M PCTINCREASE 0 MAXEXTENTS 200);

INSERT INTO ORAMON.OMON_TOOLPRIV_DTL
 VALUES (1000, 1050, 'domain01\account.name', 'Domain Account', 'SYSADMIN', NULL, NULL, 'Y', TRUNC(SYSDATE), NULL, SYSDATE, 'OPS$DBA_ADMIN', SYSDATE, 'OPS$DBA_ADMIN');

INSERT INTO ORAMON.OMON_TOOLPRIV_DTL
 VALUES (1001, 1050, 'domain01\user.name', 'User who needs SQLPLUS', 'SYSADMIN', NULL, NULL, 'N', TRUNC(SYSDATE), NULL, SYSDATE, 'OPS$DBA_ADMIN', SYSDATE, 'OPS$DBA_ADMIN');

COMMIT;