WebSVN – DevTools – Diff – /ManagerSuite/Release_Manager/trunk/web/database/Relman_export.sql

 --------------------------------------------------------
---  File created - Monday-January-18-2016
+--  File created - Thursday-July-14-2016
 --------------------------------------------------------
 --------------------------------------------------------
 --  DDL for Type RELMGR_NUMBER_TAB_T
 --------------------------------------------------------
+/
 --------------------------------------------------------
 --  DDL for Type TDICTIONARY
 --------------------------------------------------------
-  CREATE OR REPLACE TYPE "RELEASE_MANAGER"."TDICTIONARY" AS TABLE OF VARCHAR2(4000) INDEX BY VARCHAR2(4000)
+  CREATE OR REPLACE TYPE "RELEASE_MANAGER"."TDICTIONARY" AS
+  TABLE OF VARCHAR2(4000)
+/
 --------------------------------------------------------
 --  DDL for Sequence MICROSOFTSEQDTPROPERTIES
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."MICROSOFTSEQDTPROPERTIES"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 50 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_ADDITIONAL_NOTES
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_ADDITIONAL_NOTES"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 36049 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_ADDITIONAL_NOTES"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 36469 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BMCON_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BMCON_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 241 CACHE 20 NOORDER  NOCYCLE ;
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BSA_ID"  MINVALUE 8 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 28 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_BUILD_INSTANCE
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 62661 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_BUILD_INSTANCE"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 114421 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_CR_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 90946 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_CR_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 92186 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_DAEMON_INSTRUCTION_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 160868 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_DAEMON_INSTRUCTION_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 165068 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_GBE_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GBE_ID"  MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1240 NOCACHE  ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GBE_ID"  MINVALUE 40 MAXVALUE 9999999999999999999999990 INCREMENT BY 1 START WITH 1241 NOCACHE  ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_GROUP_EMAIL_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_GROUP_EMAIL_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1166 CACHE 20 NOORDER  NOCYCLE ;
+  GRANT SELECT ON "RELEASE_MANAGER"."SEQ_GROUP_EMAIL_ID" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Sequence SEQ_MSG_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_MSG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 562 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PKG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 62767 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PKG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 63747 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PROJ_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PROJ_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 861 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_PV_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1086305 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_PV_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1130245 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RCON_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 28510 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RCON_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 30010 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RELEASE_MOD
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 67296 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RELEASE_MOD"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 136416 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_RTAG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 32925 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_RTAG_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 33885 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SCHEDULED_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 27967 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SCHEDULED_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999990 INCREMENT BY 1 START WITH 28607 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SDKTAG_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 181 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDKTAG_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 641 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SDK_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDK_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 81 CACHE 20 NOORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SDK_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 161 CACHE 20 NOORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_SESSION_NUM
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1052006 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_SESSION_NUM"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1074626 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
+--  DDL for Sequence SEQ_TESTRUN_ID
+--------------------------------------------------------
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_TESTRUN_ID"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 549621 CACHE 20 NOORDER  NOCYCLE ;
+--------------------------------------------------------
 --  DDL for Sequence SEQ_UNIT_TESTS
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 359022 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_UNIT_TESTS"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 361682 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_USER_ID
 --------------------------------------------------------
    CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_USER_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 3961 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_VCS_TYPE
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VCS_TYPE"  MINVALUE 1 MAXVALUE 255 INCREMENT BY 1 START WITH 43 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VCS_TYPE"  MINVALUE 1 MAXVALUE 255 INCREMENT BY 1 START WITH 43 NOCACHE  ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_VIEW_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 5721 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VIEW_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 5901 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Sequence SEQ_VTREE_ID
 --------------------------------------------------------
-   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 29744 CACHE 20 ORDER  NOCYCLE ;
+   CREATE SEQUENCE  "RELEASE_MANAGER"."SEQ_VTREE_ID"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 30704 CACHE 20 ORDER  NOCYCLE ;
 --------------------------------------------------------
 --  DDL for Table ABT_ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."ABT_ACTION_LOG" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ABT_ACTION_LOG" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ABT_ACTION_LOG" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ACTION_LOG"
   STORAGE(INITIAL 308281344 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."ACTION_LOG"."ACTION_DATETIME" IS 'To be deprecated. Use timestamp instead';
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_LOG" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_LOG" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_LOG" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_LOG" TO "RELEASE_MANAGER_READ";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."ACTION_LOG" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."ACTION_LOG" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table ACTION_TYPE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ACTION_TYPE"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_TYPE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_TYPE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_TYPE" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_TYPE" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_TYPE" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."ACTION_TYPE" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table ADDITIONAL_NOTES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 55574528 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."ADDITIONAL_NOTES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ADDITIONAL_NOTES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ADDITIONAL_NOTES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ADDITIONAL_NOTES" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."ADDITIONAL_NOTES" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table ADVISORY_RIPPLE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."ADVISORY_RIPPLE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ADVISORY_RIPPLE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ADVISORY_RIPPLE" TO "RM_READONLY";
+  GRANT INSERT ON "RELEASE_MANAGER"."ADVISORY_RIPPLE" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table ARCHIVE_ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" TO "RM_READONLY";
+  GRANT INSERT, SELECT ON "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table ARCHIVE_DATA
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."ARCHIVE_DATA"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."ARCHIVE_DATA" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ARCHIVE_DATA" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ARCHIVE_DATA" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table AUTOBUILD_FAILURE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."AUTOBUILD_FAILURE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."AUTOBUILD_FAILURE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."AUTOBUILD_FAILURE" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."AUTOBUILD_FAILURE" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."AUTOBUILD_FAILURE" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table BUILD_ENVIRONMENTS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" TO "RELEASE_MANAGER_READ";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" TO "ARCHIVE_MANAGER";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table BUILD_ENV_DOCUMENTS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table BUILD_INSTANCES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_INSTANCES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINES" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINES" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table BUILD_MACHINE_CONFIG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG"
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG"."ACTIVE" IS 'Allows user to select deamon, otherwise its not shown unless already in use.';
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" TO "DEPLOYMENT_MANAGER";
 --------------------------------------------------------
 --  DDL for Table BUILD_ORDER
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_ORDER"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ORDER" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ORDER" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ORDER" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_ORDER" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."BUILD_ORDER" TO "ARCHIVE_MANAGER";
+--------------------------------------------------------
+--  DDL for Table BUILD_PLAN
+--------------------------------------------------------
+  CREATE TABLE "RELEASE_MANAGER"."BUILD_PLAN"
+   (	"RTAG_ID" NUMBER,
+	"BUILD_ORDER" NUMBER,
+	"PV_ID" NUMBER
+   ) SEGMENT CREATION IMMEDIATE
+  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASEM_DATA" ;
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLAN"."RTAG_ID" IS 'Identify target Release';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLAN"."BUILD_ORDER" IS 'Sequence for build';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."BUILD_PLAN"."PV_ID" IS 'Package to build';
 --------------------------------------------------------
 --  DDL for Table BUILD_SERVICE_CONFIG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table BUILD_STANDARDS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_STANDARDS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS" TO "DEPLOYMENT_MANAGER";
 --------------------------------------------------------
 --  DDL for Table BUILD_STANDARDS_ADDENDUM
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table CODE_REVIEWS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."CODE_REVIEWS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 524288 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."CODE_REVIEWS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CODE_REVIEWS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CODE_REVIEWS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CODE_REVIEWS" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."CODE_REVIEWS" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table CODE_REVIEW_URL
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 983040 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."CODE_REVIEW_URL" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CODE_REVIEW_URL" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CODE_REVIEW_URL" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table CQ_HISTORY
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."CQ_HISTORY"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_HISTORY" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_HISTORY" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_HISTORY" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_HISTORY" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_HISTORY" TO "ACCESS_MANAGER";
 --------------------------------------------------------
 --  DDL for Table CQ_ISSUES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."CQ_ISSUES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 4194304 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_ISSUES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_ISSUES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_ISSUES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_ISSUES" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_ISSUES" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."CQ_ISSUES" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_ISSUES" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table CQ_SOFTWARE_ISSUE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE"
  LOB ("CUSTOM_FIELD_05") STORE AS BASICFILE (
   TABLESPACE "RELEASEM_DATA" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION
   NOCACHE LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" TO "ACCESS_MANAGER";
 --------------------------------------------------------
 --  DDL for Table CQ_STATEDEF
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."CQ_STATEDEF"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_STATEDEF" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_STATEDEF" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_STATEDEF" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_STATEDEF" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_STATEDEF" TO "ACCESS_MANAGER";
 --------------------------------------------------------
 --  DDL for Table CQ_USERS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."CQ_USERS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_USERS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_USERS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_USERS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_USERS" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."CQ_USERS" TO "ACCESS_MANAGER";
 --------------------------------------------------------
 --  DDL for Table DAEMON_ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."DAEMON_ACTION_LOG" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DAEMON_ACTION_LOG" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DAEMON_ACTION_LOG" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table DAEMON_INSTRUCTIONS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS"
    COMMENT ON COLUMN "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS"."OP_CODE" IS 'The instruction op-code';
    COMMENT ON COLUMN "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS"."SCHEDULED_DATETIME" IS 'The datetime after which the instruction can be carried out.';
    COMMENT ON COLUMN "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS"."REPEAT_SECS" IS 'The number of seconds to add to scheduled_datetime when instruction is repeating';
    COMMENT ON COLUMN "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS"."ADDED_DATETIME" IS 'The datetime the instruction was added to the table - informational only';
    COMMENT ON COLUMN "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS"."USER_ID" IS 'The user who added the instruction to the table  - informational only';
+  GRANT SELECT ON "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table DASH_BOARD
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."DASH_BOARD"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."DASH_BOARD" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DASH_BOARD" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DASH_BOARD" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table DEPRECATED_PACKAGES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."DEPRECATED_PACKAGES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DEPRECATED_PACKAGES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DEPRECATED_PACKAGES" TO "RM_READONLY";
+  GRANT INSERT ON "RELEASE_MANAGER"."DEPRECATED_PACKAGES" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table DO_NOT_RIPPLE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 655360 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."DO_NOT_RIPPLE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DO_NOT_RIPPLE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DO_NOT_RIPPLE" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."DO_NOT_RIPPLE" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."DO_NOT_RIPPLE" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."DO_NOT_RIPPLE" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."DO_NOT_RIPPLE" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table GBE_MACHTYPE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."GBE_MACHTYPE"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."GBE_MACHTYPE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."GBE_MACHTYPE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."GBE_MACHTYPE" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."GBE_MACHTYPE" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."GBE_MACHTYPE" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table IGNORE_WARNINGS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 3145728 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."IGNORE_WARNINGS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."IGNORE_WARNINGS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."IGNORE_WARNINGS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."IGNORE_WARNINGS" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."IGNORE_WARNINGS" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table JIRA_ISSUES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."JIRA_ISSUES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 262144 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."JIRA_ISSUES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."JIRA_ISSUES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."JIRA_ISSUES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."JIRA_ISSUES" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."JIRA_ISSUES" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."JIRA_ISSUES" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table LICENCES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."LICENCES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."LICENCES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."LICENCES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."LICENCES" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table LICENCING
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."LICENCING"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."LICENCING" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."LICENCING" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."LICENCING" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table LXR_STATE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."LXR_STATE"
    COMMENT ON COLUMN "RELEASE_MANAGER"."LXR_STATE"."RTAG_ID" IS 'Link to Release_Tags';
    COMMENT ON COLUMN "RELEASE_MANAGER"."LXR_STATE"."LXRSERVER" IS 'Written by server - I:Indexed, C:Closing, N:Not Known. May be InProgress.';
    COMMENT ON TABLE "RELEASE_MANAGER"."LXR_STATE"  IS 'Contains data updated by the LXR server.
 This table is writable by a user known to the LXR Server';
+  GRANT ALTER, DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."LXR_STATE" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table MEMBERS_GROUP
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."MEMBERS_GROUP"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."MEMBERS_GROUP" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MEMBERS_GROUP" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MEMBERS_GROUP" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MEMBERS_GROUP" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."MEMBERS_GROUP" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table MESSAGE_BOARD
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."MESSAGE_BOARD"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."MESSAGE_BOARD" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MESSAGE_BOARD" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MESSAGE_BOARD" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MESSAGE_BOARD" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table MICROSOFTDTPROPERTIES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table NOTE_MANAGER
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."NOTE_MANAGER"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."NOTE_MANAGER" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."NOTE_MANAGER" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."NOTE_MANAGER" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."NOTE_MANAGER" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table NOTIFICATION_HISTORY
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."NOTIFICATION_HISTORY" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."NOTIFICATION_HISTORY" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."NOTIFICATION_HISTORY" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."NOTIFICATION_HISTORY" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."NOTIFICATION_HISTORY" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table PACKAGES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGES"
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGES"."DEFAULT_PEGGED" IS 'Default pegged state for packages that are added to a release.';
    COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGES"."DEFAULT_ADVISORY_RIPPLE" IS 'Default advisiory ripple state for packages that are added to a release.';
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGES" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGES" TO "DEPLOYMENT_MANAGER_READ";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PACKAGES" TO "DEPLOYMENT_MANAGER";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PACKAGES" TO "CODE_INSPECTION";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGES" TO "CODE_INSPECTION_READ";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_BUILD_ENV
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" TO "RELEASE_MANAGER_READ";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" TO "ARCHIVE_MANAGER";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_BUILD_INFO
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_DEPENDENCIES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES"
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES"."PV_ID" IS 'Package Version Identifier';
    COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES"."DPV_ID" IS 'Depends on this package version';
    COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES"."BUILD_TYPE" IS 'B:BuildPkgArchive, L:LinkPkgArchive';
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_DOCUMENTS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_INTEREST
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_INTEREST" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_INTEREST" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_INTEREST" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_METRICS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_METRICS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 12582912 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_METRICS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_METRICS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_METRICS" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_PATCHES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 327680 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PATCHES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PATCHES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PATCHES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PATCHES" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PATCHES" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."PACKAGE_PATCHES" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PATCHES" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_PROCESSES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PROCESSES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PROCESSES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_PROCESSES" TO "RM_READONLY";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PACKAGE_PROCESSES" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."PACKAGE_PROCESSES" TO "ARCHIVE_MANAGER";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PACKAGE_PROCESSES" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PACKAGE_VERSIONS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS"
 	"BS_ID" NUMBER,
 	"IS_AUTOBUILDABLE" CHAR(1 BYTE),
 	"SBOM_PRIORITY" CHAR(1 BYTE),
 	"RIPPLE_FIELD" CHAR(1 CHAR),
 	"MAXIMUM_BUILD_TIME" NUMBER,
-	"ESTIMATED_COMPLETION_TIME" DATE,
+	"BUILD_TIME" NUMBER,
 	"MAJOR_LIMIT" NUMBER(10,0),
 	"MINOR_LIMIT" NUMBER(10,0),
 	"PATCH_LIMIT" NUMBER(10,0),
 	"BUILD_NUMBER_LIMIT" NUMBER(10,0),
 	"VCS_TYPE_ID" NUMBER,
   STORAGE(INITIAL 134217728 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_VERSIONS"."RELEASED_AT" IS 'No longer used';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_VERSIONS"."IS_DEPLOYABLE" IS 'null:No, NonNull:Yes Y:Yes';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_VERSIONS"."IS_AUTOBUILDABLE" IS 'Y: Indicates that the package has been built on a build machine';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."PACKAGE_VERSIONS"."BUILD_TIME" IS 'Duration of last build';
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "RELEASE_MANAGER_READ";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT, SELECT ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "ARCHIVE_MANAGER";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PACKAGE_VERSIONS" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PEGGED_VERSIONS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PEGGED_VERSIONS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PEGGED_VERSIONS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PEGGED_VERSIONS" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table PLANNED
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PLANNED"
 S:Subtract existing Version.
 R:Add New Version';
    COMMENT ON TABLE "RELEASE_MANAGER"."PLANNED"  IS 'This table contains WORK IN PROGRESS packages';
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PLANNED_VERSIONS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PLANNED_VERSIONS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED_VERSIONS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED_VERSIONS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLANNED_VERSIONS" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table PLATFORMS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PLATFORMS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PLATFORMS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLATFORMS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLATFORMS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLATFORMS" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLATFORMS" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PLATFORMS" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PROCESSES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PROCESSES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PROCESSES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROCESSES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROCESSES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROCESSES" TO "RELEASE_MANAGER_READ";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PROCESSES" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT, SELECT ON "RELEASE_MANAGER"."PROCESSES" TO "ARCHIVE_MANAGER";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PROCESSES" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PRODUCT_COMPONENTS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 31457280 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_COMPONENTS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_COMPONENTS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_COMPONENTS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_COMPONENTS" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_COMPONENTS" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."PRODUCT_COMPONENTS" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_COMPONENTS" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table PRODUCT_STATES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PRODUCT_STATES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_STATES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_STATES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PRODUCT_STATES" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table PROJECTS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PROJECTS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECTS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECTS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECTS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECTS" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECTS" TO "DEPLOYMENT_MANAGER_READ";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PROJECTS" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECTS" TO "ACCESS_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECTS" TO "ARCHIVE_MANAGER";
+  GRANT DELETE, INSERT, SELECT, UPDATE ON "RELEASE_MANAGER"."PROJECTS" TO "CODE_INSPECTION";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECTS" TO "CODE_INSPECTION_READ";
 --------------------------------------------------------
 --  DDL for Table PROJECT_ACTION_LOG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 851968 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_ACTION_LOG" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_ACTION_LOG" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_ACTION_LOG" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_ACTION_LOG" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."PROJECT_ACTION_LOG" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table PROJECT_EXTENTIONS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."PROJECT_EXTENTIONS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_EXTENTIONS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_EXTENTIONS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_EXTENTIONS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_EXTENTIONS" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_EXTENTIONS" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."PROJECT_EXTENTIONS" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table RELEASE_COMPONENTS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RELEASE_COMPONENTS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 2828009472 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_COMPONENTS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_COMPONENTS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_COMPONENTS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_COMPONENTS" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."RELEASE_COMPONENTS" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table RELEASE_CONFIG
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RELEASE_CONFIG"
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONFIG"."GBE_ID" IS 'Do not use. Data should come from build_machine_config';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONFIG"."DAEMON_HOSTNAME" IS 'Do not use. Data should come from build_machine_config';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONFIG"."BMCON_ID" IS 'Link to the build_machine_config table';
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONFIG" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONFIG" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONFIG" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONFIG" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONFIG" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table RELEASE_CONTENT
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RELEASE_CONTENT"
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."PKG_ID" IS 'NotUsed any more. Was:Package that has been deprecated';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."DEPRECATED_STATE" IS '6: Deprecated Package, 7: Deprecated Dependent';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_CONTENT"."SDKTAG_ID" IS 'Pkg imported via SDK';
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_CONTENT" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table RELEASE_LINKS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RELEASE_LINKS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_LINKS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_LINKS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_LINKS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_LINKS" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table RELEASE_METRICS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RELEASE_METRICS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_METRICS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_METRICS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_METRICS" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table RELEASE_MODIFIED
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RELEASE_MODIFIED"
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."REBUILD_ENV" IS 'Y: Rebuild Package State';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."REBUILD_STAMP" IS 'Not used ?';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."OFFICIAL_ID" IS 'User last changed OFFICIAL state';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."BUILD_AGE" IS 'Days without building before warning is shown';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RELEASE_TAGS"."LXR" IS 'Y:Enable LXR';
---------------------------------------------------------
---  DDL for Table RIPPLE_FIELD_STATES
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "DM_READONLY";
---------------------------------------------------------
-  CREATE TABLE "RELEASE_MANAGER"."RIPPLE_FIELD_STATES"
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "MS_READONLY";
-   (	"STATE_ID" NUMBER,
-	"STATE_ACRONYM" CHAR(1 BYTE),
-	"STATE_NAME" VARCHAR2(50 BYTE)
-   ) SEGMENT CREATION IMMEDIATE
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "RM_READONLY";
-  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "RELEASE_MANAGER_READ";
-  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "DEPLOYMENT_MANAGER";
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "ARCHIVE_MANAGER";
-  TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."RELEASE_TAGS" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table RM_PACKAGE_ISSUES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RM_PACKAGE_ISSUES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PACKAGE_ISSUES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PACKAGE_ISSUES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PACKAGE_ISSUES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PACKAGE_ISSUES" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table RM_PKG_ISSUES
 --------------------------------------------------------
   CREATE GLOBAL TEMPORARY TABLE "RELEASE_MANAGER"."RM_PKG_ISSUES"
 	"DPKG_NAME" VARCHAR2(50 BYTE),
 	"DPKG_VERSION" VARCHAR2(50 BYTE),
 	"ISS_DB" NUMBER,
 	"ISS_ID" NUMBER
    ) ON COMMIT PRESERVE ROWS ;
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table RUNTIME_DEPENDENCIES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 7340032 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" TO "RELEASE_MANAGER_READ";
+  GRANT INSERT ON "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" TO "ARCHIVE_MANAGER";
 --------------------------------------------------------
 --  DDL for Table RUN_LEVEL
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RUN_LEVEL"
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."RCON_ID" IS 'Link to the Release_config table';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_BUILD_FILES" IS 'The current build file. Set by the Master, consumed by the Slaves.';
-   COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_RUN_LEVEL" IS 'Daemon indiactes its current state';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_RUN_LEVEL" IS 'Daemon indiactes its current state. 1:Cannot Continue, 2:Paused, 3:Active, 4:Idle, 5:Waiting, 6:Publishing';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."PAUSE" IS 'The daemon should pause at the end of the current build.Null:Run, 1:Pause, 2:Disable';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_PKG_ID_BEING_BUILT" IS 'pkg_id of the package currently being built';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."KEEP_ALIVE" IS 'DateTime of the last database enquiry made by the daemon. Used to locate dead daemons.';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."CURRENT_PV_ID" IS 'The PV_ID of the package currently being built.';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL"."LAST_BUILD" IS 'The DateTime that the last build started. This does not include dummy builds. Used to determine unused daemons.';
+  GRANT SELECT ON "RELEASE_MANAGER"."RUN_LEVEL" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RUN_LEVEL" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RUN_LEVEL" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table RUN_LEVEL_SCHEDULE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE"
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE"."SCHEDULED_ID" IS 'Unique entry identifier';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE"."SCHEDULED_PAUSE" IS 'Start DateTime of the outage';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE"."SCHEDULED_RESUME" IS 'End DateTime of the outage';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE"."REPEAT" IS '0:Once, 1:Daily, 7:Weekly';
    COMMENT ON COLUMN "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE"."INDEFINITE_PAUSE" IS 'Non Null indicates indefinite pause';
+  GRANT SELECT ON "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table SDK_CONTENT
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."SDK_CONTENT"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 524288 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_ENV_STATES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_ENV_STATES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_ENV_STATES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_ENV_STATES" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table TEMP_SASH
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."TEMP_SASH"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_SASH" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_SASH" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_SASH" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_SASH" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table TEMP_TREE_BROWSE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."TEMP_TREE_BROWSE"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_TREE_BROWSE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_TREE_BROWSE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_TREE_BROWSE" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEMP_TREE_BROWSE" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table TEST_RUN
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."TEST_RUN"
 	"PLATFORM" VARCHAR2(50 BYTE),
 	"TYPE" VARCHAR2(1 BYTE),
 	"TEST_NAME" VARCHAR2(200 BYTE),
 	"TEST_OUTCOME" VARCHAR2(20 BYTE),
 	"TIME_TAKEN" NUMBER,
-	"FAIL_MESSAGE" CLOB
+	"FAIL_MESSAGE" CLOB,
+	"TESTRUN_ID" NUMBER
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA"
    COMMENT ON COLUMN "RELEASE_MANAGER"."TEST_RUN"."PLATFORM" IS 'Target Platform';
    COMMENT ON COLUMN "RELEASE_MANAGER"."TEST_RUN"."TYPE" IS 'P or D';
    COMMENT ON COLUMN "RELEASE_MANAGER"."TEST_RUN"."TEST_OUTCOME" IS 'PASS/FAIL/SKIP';
    COMMENT ON COLUMN "RELEASE_MANAGER"."TEST_RUN"."TIME_TAKEN" IS 'Test Duration in milliseconds';
    COMMENT ON COLUMN "RELEASE_MANAGER"."TEST_RUN"."FAIL_MESSAGE" IS 'Failure Message';
+   COMMENT ON COLUMN "RELEASE_MANAGER"."TEST_RUN"."TESTRUN_ID" IS 'Unique Id. Used to generate a primary key.';
 --------------------------------------------------------
 --  DDL for Table TEST_TYPES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."TEST_TYPES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."TEST_TYPES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEST_TYPES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEST_TYPES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEST_TYPES" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEST_TYPES" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEST_TYPES" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."TEST_TYPES" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table UNIT_TESTS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."UNIT_TESTS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 31457280 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."UNIT_TESTS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."UNIT_TESTS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."UNIT_TESTS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."UNIT_TESTS" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."UNIT_TESTS" TO "DEPLOYMENT_MANAGER";
+  GRANT INSERT ON "RELEASE_MANAGER"."UNIT_TESTS" TO "ARCHIVE_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."UNIT_TESTS" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table VALIDATION_RULES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."VALIDATION_RULES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."VALIDATION_RULES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VALIDATION_RULES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VALIDATION_RULES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VALIDATION_RULES" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table VCS_TYPE
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."VCS_TYPE"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."VCS_TYPE" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VCS_TYPE" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VCS_TYPE" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Table VIEWS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."VIEWS"
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."VIEWS"."OWNER_ID" IS '0:Public';
    COMMENT ON COLUMN "RELEASE_MANAGER"."VIEWS"."BASE_VIEW" IS 'Y:Base View';
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEWS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEWS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEWS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEWS" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table VIEW_DEF
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."VIEW_DEF"
   TABLESPACE "RELEASEM_DATA" ;
    COMMENT ON COLUMN "RELEASE_MANAGER"."VIEW_DEF"."VIEW_ID" IS 'Non Base View ID';
    COMMENT ON COLUMN "RELEASE_MANAGER"."VIEW_DEF"."PKG_ID" IS 'Package ID';
    COMMENT ON TABLE "RELEASE_MANAGER"."VIEW_DEF"  IS 'Packages in a non-baseview';
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEW_DEF" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEW_DEF" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEW_DEF" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEW_DEF" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table VIEW_SETTINGS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."VIEW_SETTINGS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEW_SETTINGS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEW_SETTINGS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEW_SETTINGS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VIEW_SETTINGS" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table VTREES
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."VTREES"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table VTREES_WORLD
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."VTREES_WORLD"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES_WORLD" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES_WORLD" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES_WORLD" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES_WORLD" TO "RELEASE_MANAGER_READ";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES_WORLD" TO "DEPLOYMENT_MANAGER";
+  GRANT SELECT ON "RELEASE_MANAGER"."VTREES_WORLD" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Table WORK_IN_PROGRESS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."WORK_IN_PROGRESS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."WORK_IN_PROGRESS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."WORK_IN_PROGRESS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."WORK_IN_PROGRESS" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Table WORLDS
 --------------------------------------------------------
   CREATE TABLE "RELEASE_MANAGER"."WORLDS"
    ) SEGMENT CREATION IMMEDIATE
   PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
+  GRANT SELECT ON "RELEASE_MANAGER"."WORLDS" TO "DM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."WORLDS" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."WORLDS" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."WORLDS" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for View ENVIRONMENT_VIEW
 --------------------------------------------------------
   CREATE OR REPLACE FORCE VIEW "RELEASE_MANAGER"."ENVIRONMENT_VIEW" ("ENV_AREA", "PV_ID", "RTAG_ID", "VIEW_ID", "PKG_STATE", "DEPRECATED_STATE", "INSERTOR_ID", "INSERT_STAMP", "OPERATION") AS
  NULL AS DEPRECATED_STATE,
     NULL AS INSERTOR_ID,
     NULL AS INSERT_STAMP,
     pl.operation
 FROM PLANNED pl;
+  GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."ENVIRONMENT_VIEW" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for View RM_PKG_ISSUES_ID
 --------------------------------------------------------
   CREATE OR REPLACE FORCE VIEW "RELEASE_MANAGER"."RM_PKG_ISSUES_ID" ("ISS_ID", "PKG_VERSION") AS
   SELECT DISTINCT ISS_ID, PKG_VERSION FROM RM_PACKAGE_ISSUES WHERE ISS_ID IS NOT NULL
+;
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES_ID" TO "MS_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES_ID" TO "RM_READONLY";
+  GRANT SELECT ON "RELEASE_MANAGER"."RM_PKG_ISSUES_ID" TO "RELEASE_MANAGER_READ";
 --------------------------------------------------------
 --  DDL for Index PK_LICENCES
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."PK_LICENCES" ON "RELEASE_MANAGER"."LICENCES" ("LICENCE")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
 --------------------------------------------------------
+--  DDL for Index BUILD_PLAN_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_PLAN_PK" ON "RELEASE_MANAGER"."BUILD_PLAN" ("RTAG_ID", "BUILD_ORDER", "PV_ID")
+  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index SDK_CONTENT_INDEX1
 --------------------------------------------------------
   CREATE INDEX "RELEASE_MANAGER"."SDK_CONTENT_INDEX1" ON "RELEASE_MANAGER"."SDK_CONTENT" ("SDKTAG_ID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA" ;
 --------------------------------------------------------
+--  DDL for Index TEST_RUN_INDEX1
+--------------------------------------------------------
+  CREATE INDEX "RELEASE_MANAGER"."TEST_RUN_INDEX1" ON "RELEASE_MANAGER"."TEST_RUN" ("BUILD_ID")
+  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASEM_DATA" ;
+--------------------------------------------------------
+--  DDL for Index RUN_LEVEL_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."RUN_LEVEL_PK" ON "RELEASE_MANAGER"."RUN_LEVEL" ("RCON_ID")
+  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index BUILD_SERVICE_CONFIG_INDEX1
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG_INDEX1" ON "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" ("SERVICE")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX" ;
 --------------------------------------------------------
+--  DDL for Index TEST_RUN_PK
+--------------------------------------------------------
+  CREATE UNIQUE INDEX "RELEASE_MANAGER"."TEST_RUN_PK" ON "RELEASE_MANAGER"."TEST_RUN" ("TESTRUN_ID")
+  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASEM_DATA" ;
+--------------------------------------------------------
 --  DDL for Index CQ_HISTORY_INDEX1
 --------------------------------------------------------
   CREATE UNIQUE INDEX "RELEASE_MANAGER"."CQ_HISTORY_INDEX1" ON "RELEASE_MANAGER"."CQ_HISTORY" ("DBID")
   PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   TABLESPACE "RELEASEM_INDX" ;
 --------------------------------------------------------
 --  Constraints for Table RELEASE_TAGS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" ADD CONSTRAINT "PK_RELEASE_TAGS" PRIMARY KEY ("RTAG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_TAGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table SDK_NAMES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."SDK_NAMES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."SDK_NAMES" MODIFY ("VIEW_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."SDK_NAMES" MODIFY ("PROJ_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."SDK_NAMES" ADD CONSTRAINT "SDK_NAMES_PK" PRIMARY KEY ("SDK_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   ALTER TABLE "RELEASE_MANAGER"."SDK_NAMES" MODIFY ("SDK_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table SDK_TAGS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" ADD CONSTRAINT "SDK_TAGS_PK" PRIMARY KEY ("SDKTAG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDK_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDKTAG_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."SDK_TAGS" MODIFY ("SDKTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
---  Constraints for Table RIPPLE_FIELD_STATES
---------------------------------------------------------
-  ALTER TABLE "RELEASE_MANAGER"."RIPPLE_FIELD_STATES" MODIFY ("STATE_ACRONYM" NOT NULL DISABLE);
-  ALTER TABLE "RELEASE_MANAGER"."RIPPLE_FIELD_STATES" MODIFY ("STATE_ID" NOT NULL ENABLE);
---------------------------------------------------------
 --  Constraints for Table RUNTIME_DEPENDENCIES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" MODIFY ("MOD_USER" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RUNTIME_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table LXR_STATE
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."LXR_STATE" ADD CONSTRAINT "LXR_STATE_PK" PRIMARY KEY ("RTAG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA"  ENABLE;
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_PROCESSES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES" MODIFY ("PROC_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PROCESSES" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table DO_NOT_RIPPLE
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."DO_NOT_RIPPLE" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table RELEASE_COMPONENTS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_COMPONENTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table VIEW_SETTINGS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VIEW_SETTINGS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."VIEW_SETTINGS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VIEW_SETTINGS" MODIFY ("USER_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table WORLDS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."WORLDS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."WORLDS" ADD CONSTRAINT "PK_WORLDS" PRIMARY KEY ("WORLD_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."WORLDS" MODIFY ("WORLD_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table UNIT_TESTS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" MODIFY ("TEST_TYPES_FK" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."UNIT_TESTS" MODIFY ("TEST_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_DOCUMENTS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" MODIFY ("DOC_NUM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" MODIFY ("DOC_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_BUILD_INFO
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" MODIFY ("BM_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table ADVISORY_RIPPLE
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ADVISORY_RIPPLE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table PRODUCT_STATES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PRODUCT_STATES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PRODUCT_STATES" ADD CONSTRAINT "PRODUCT_STATES_PK" PRIMARY KEY ("STATE_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PRODUCT_STATES" MODIFY ("STATE_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PRODUCT_COMPONENTS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS" MODIFY ("OS_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PRODUCT_COMPONENTS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_PATCHES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("INSTALL_ORDER" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("PATCH_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_PATCHES" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table RUN_LEVEL_SCHEDULE
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" ADD PRIMARY KEY ("SCHEDULED_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 262144 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL_SCHEDULE" MODIFY ("SCHEDULED_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table MICROSOFTDTPROPERTIES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" ADD CONSTRAINT "MICROSOFT_PK_DTPROPERTIES" PRIMARY KEY ("ID", "PROPERTY")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."MICROSOFTDTPROPERTIES" MODIFY ("ID" CONSTRAINT "MICROSOFT_NN_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table NOTE_MANAGER
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."NOTE_MANAGER" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."NOTE_MANAGER" ADD CONSTRAINT "PKNOTE_MANAGER1" PRIMARY KEY ("NID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."NOTE_MANAGER" MODIFY ("NID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table BUILD_SERVICE_CONFIG
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" MODIFY ("CONFIG" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_SERVICE_CONFIG" MODIFY ("SERVICE" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table GBE_MACHTYPE
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" MODIFY ("BM_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."GBE_MACHTYPE" ADD PRIMARY KEY ("GBE_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTION_DATETIME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."ACTION_LOG" MODIFY ("ACTION_TIMESTAMP" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table SDK_CONTENT
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("SDKPKG_STATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."SDK_CONTENT" MODIFY ("SDKTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table ADDITIONAL_NOTES
   ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("MOD_USER" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("NOTE_TITLE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" MODIFY ("NOTE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ADDITIONAL_NOTES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table BUILD_STANDARDS_ADDENDUM
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" ADD CONSTRAINT "BUILD_STANDARDS_ADDENDUM_PK" PRIMARY KEY ("BSA_ID")
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BS_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" MODIFY ("BSA_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table TEST_TYPES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" ADD CONSTRAINT "PK_TEST_TYPES" PRIMARY KEY ("TEST_TYPE_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."TEST_TYPES" MODIFY ("TEST_TYPE_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table BUILD_INSTANCES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" MODIFY ("STATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" MODIFY ("BUILD_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" MODIFY ("RTAG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_INSTANCES" MODIFY ("TIMESTAMP" NOT NULL ENABLE);
   TABLESPACE "RELEASEM_DATA"  ENABLE;
 --------------------------------------------------------
 --  Constraints for Table TEMP_ENV_STATES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("TES_STATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("LEVEL_NUM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_STATES" MODIFY ("SESSION_NUM" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table VTREES_WORLD
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" MODIFY ("VTREE_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VTREES_WORLD" MODIFY ("WORLD_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table RELEASE_CONFIG
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" ADD PRIMARY KEY ("RCON_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONFIG" MODIFY ("RCON_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table VIEWS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VIEWS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."VIEWS" ADD CONSTRAINT "PK_VIEWS" PRIMARY KEY ("VIEW_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."VIEWS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table JIRA_ISSUES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."JIRA_ISSUES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."JIRA_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PLATFORMS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PLATFORMS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PLATFORMS" MODIFY ("NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PLATFORMS" MODIFY ("CODE" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table IGNORE_WARNINGS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" MODIFY ("DPV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."IGNORE_WARNINGS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table DASH_BOARD
   ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("TOTAL_PACKAGES" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("AUTOMATED_PACKAGES" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("LAST_BUILD_TIME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("RTAG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" MODIFY ("PROJ_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DASH_BOARD" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table ACTION_TYPE
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" ADD CONSTRAINT "UNQ_ACTTYPE_ID" PRIMARY KEY ("ACTTYPE_ID")
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" MODIFY ("NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ACTION_TYPE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_VERSIONS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" ADD CONSTRAINT "PK_PACKAGE_VERSIONS" PRIMARY KEY ("PV_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 5242880 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table CQ_SOFTWARE_ISSUE
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" ADD CONSTRAINT "CQ_SOFTWARE_ISSUE_PK" PRIMARY KEY ("DBID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."CQ_SOFTWARE_ISSUE" MODIFY ("DBID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_INTEREST
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("USER_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("PROJ_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_INTEREST" MODIFY ("PKG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table RELEASE_CONTENT
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("PKG_STATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("INSERTOR_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("INSERT_STAMP" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("BASE_VIEW_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_CONTENT" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table RELEASE_METRICS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_METRICS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_METRICS" ADD CONSTRAINT "UNQ_RELEASE_METRICS" UNIQUE ("RTAG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_METRICS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PROJECT_EXTENTIONS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PROJECT_EXTENTIONS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PROJECT_EXTENTIONS" MODIFY ("EXT_NAME" NOT NULL ENABLE);
 --------------------------------------------------------
+--  Constraints for Table RUN_LEVEL
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL" ADD CONSTRAINT "RUN_LEVEL_PK" PRIMARY KEY ("RCON_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASEM_DATA"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL" MODIFY ("RCON_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."RUN_LEVEL" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
+--------------------------------------------------------
 --  Constraints for Table ABT_ACTION_LOG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG" MODIFY ("RCON_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table DAEMON_ACTION_LOG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG" MODIFY ("RCON_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DAEMON_ACTION_LOG" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_METRICS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_METRICS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_METRICS" ADD CONSTRAINT "UNQ_PACKAGE_METRICS" UNIQUE ("PV_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 4194304 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_METRICS" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table CQ_USERS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_USERS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."CQ_USERS" ADD CONSTRAINT "CQ_USERS_PK" PRIMARY KEY ("DBID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("DATE_OF_REVIEW" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("URL" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("PROJ_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" MODIFY ("CR_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEW_URL" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table CQ_STATEDEF
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."CQ_STATEDEF" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."CQ_STATEDEF" ADD CONSTRAINT "CQ_STATEDEF_PK" PRIMARY KEY ("ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA"  ENABLE;
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" MODIFY ("GROUP_EMAIL_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."AUTOBUILD_FAILURE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table BUILD_MACHINE_CONFIG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" ADD CONSTRAINT "PK_BUILD_MACHINE_CONFIG" PRIMARY KEY ("BMCON_ID")
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("GBE_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("MACHINE_HOSTNAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("DISPLAY_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("BMCON_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINE_CONFIG" MODIFY ("ACTIVE" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table TEST_RUN
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" ADD CONSTRAINT "TEST_RUN_PK" PRIMARY KEY ("TESTRUN_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASEM_DATA"  ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" MODIFY ("TESTRUN_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" MODIFY ("TYPE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" MODIFY ("PLATFORM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" MODIFY ("TEST_OUTCOME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" MODIFY ("TEST_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEST_RUN" MODIFY ("BUILD_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table VIEW_DEF
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VIEW_DEF" MODIFY ("VIEW_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table BUILD_STANDARDS
 --------------------------------------------------------
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS" MODIFY ("BS_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS" MODIFY ("BS_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_BUILD_ENV
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" MODIFY ("BE_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_ENV" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table RELEASE_MODIFIED
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_MODIFIED" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_MODIFIED" MODIFY ("RTAG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_MODIFIED" ADD CONSTRAINT "RELEASE_MODIFIED_PK" PRIMARY KEY ("RTAG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA"  ENABLE;
 --------------------------------------------------------
 --  Constraints for Table TEMP_ENV_DEPS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("DPV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("SESSION_NUM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."TEMP_ENV_DEPS" MODIFY ("DPKG_ID" NOT NULL ENABLE);
   TABLESPACE "RELEASEM_DATA"  ENABLE;
 --------------------------------------------------------
 --  Constraints for Table VTREES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VTREES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."VTREES" ADD CONSTRAINT "PK_VTREES" PRIMARY KEY ("VTREE_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."VTREES" MODIFY ("VTREE_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table NOTIFICATION_HISTORY
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" ADD CONSTRAINT "PK_NOTIFICATION_HISTORY" PRIMARY KEY ("RTAG_ID", "PV_ID", "USER_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 2097152 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."NOTIFICATION_HISTORY" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table RELEASE_LINKS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" MODIFY ("REF_RTAG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."RELEASE_LINKS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PACKAGES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGES" ADD CONSTRAINT "PK_PACKAGES" PRIMARY KEY ("PKG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGES" MODIFY ("PKG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PROJECTS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PROJECTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PROJECTS" ADD CONSTRAINT "PK_PROJECTS" PRIMARY KEY ("PROJ_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PROJECTS" MODIFY ("PROJ_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table LICENCING
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LICENCING" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."LICENCING" ADD CONSTRAINT "LICENCING_PK" PRIMARY KEY ("PV_ID", "LICENCE")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_DATA"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."LICENCING" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table MESSAGE_BOARD
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."MESSAGE_BOARD" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."MESSAGE_BOARD" ADD CONSTRAINT "PK_MESSAGE_BOARD" PRIMARY KEY ("MSG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."MESSAGE_BOARD" MODIFY ("MSG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PROJECT_ACTION_LOG
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" MODIFY ("ACTTYPE_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" MODIFY ("PROJ_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" MODIFY ("ACTION_DATETIME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PROJECT_ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table ARCHIVE_DATA
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_DATA" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_DATA" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_DATA" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
+--  Constraints for Table BUILD_PLAN
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD CONSTRAINT "BUILD_PLAN_PK" PRIMARY KEY ("RTAG_ID", "BUILD_ORDER", "PV_ID")
+  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
+  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
+  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
+  TABLESPACE "RELEASEM_DATA"  ENABLE;
+--------------------------------------------------------
 --  Constraints for Table VALIDATION_RULES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VALIDATION_RULES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."VALIDATION_RULES" MODIFY ("IS_REQUIRED" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."VALIDATION_RULES" MODIFY ("FIELD_NAME" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table LICENCES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."LICENCES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."LICENCES" ADD CONSTRAINT "PK_LICENCES" PRIMARY KEY ("LICENCE")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."LICENCES" MODIFY ("LICENCE" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table MEMBERS_GROUP
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."MEMBERS_GROUP" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."MEMBERS_GROUP" MODIFY ("GROUP_EMAIL_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table CQ_ISSUES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("MOD_DATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_STATE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("ISS_DB" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CQ_ISSUES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table ARCHIVE_ACTION_LOG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" MODIFY ("DESCRIPTION" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" MODIFY ("RTAG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" MODIFY ("DATE_TIME_STAMP" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" MODIFY ("USER_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."ARCHIVE_ACTION_LOG" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table CODE_REVIEWS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEWS" MODIFY ("PV_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."CODE_REVIEWS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table PLANNED
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PLANNED" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PLANNED" ADD CONSTRAINT "UNIQUE_PV_RTAG" UNIQUE ("PV_ID", "RTAG_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PLANNED" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table VCS_TYPE
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."VCS_TYPE" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."VCS_TYPE" ADD CONSTRAINT "VCS_TYPE_PK" PRIMARY KEY ("VCS_TYPE_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINES" MODIFY ("BM_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINES" MODIFY ("BM_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_MACHINES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table PEGGED_VERSIONS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PEGGED_VERSIONS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table DAEMON_INSTRUCTIONS
 --------------------------------------------------------
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" MODIFY ("OP_CODE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" MODIFY ("DAEMON_INSTRUCTIONS_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DAEMON_INSTRUCTIONS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table WORK_IN_PROGRESS
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("VIEW_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."WORK_IN_PROGRESS" MODIFY ("RTAG_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table BUILD_ENV_DOCUMENTS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" MODIFY ("DOC_NUM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENV_DOCUMENTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table BUILD_ORDER
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("PV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("STEP_NUM" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table PACKAGE_DEPENDENCIES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("BUILD_TYPE" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("DPKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("DPV_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" MODIFY ("PV_ID" NOT NULL ENABLE);
 --------------------------------------------------------
 --  Constraints for Table PROCESSES
 --------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PROCESSES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
   ALTER TABLE "RELEASE_MANAGER"."PROCESSES" ADD CONSTRAINT "PROCESSES_PK" PRIMARY KEY ("PROC_ID")
   USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
   STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   STORAGE(INITIAL 131072 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
   PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
   TABLESPACE "RELEASEM_INDX"  ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" MODIFY ("BE_NAME" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" MODIFY ("BE_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_ENVIRONMENTS" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Constraints for Table DEPRECATED_PACKAGES
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("COMMENTS" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("PKG_ID" NOT NULL ENABLE);
   ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" MODIFY ("RTAG_ID" NOT NULL ENABLE);
+  ALTER TABLE "RELEASE_MANAGER"."DEPRECATED_PACKAGES" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
 --------------------------------------------------------
 --  Ref Constraints for Table ABT_ACTION_LOG
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."ABT_ACTION_LOG" ADD FOREIGN KEY ("RCON_ID")
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" ADD CONSTRAINT "FK_BO_PV_ID" FOREIGN KEY ("PV_ID")
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") DISABLE;
   ALTER TABLE "RELEASE_MANAGER"."BUILD_ORDER" ADD CONSTRAINT "FK_BO_RTAG_ID" FOREIGN KEY ("RTAG_ID")
 	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ENABLE;
+--------------------------------------------------------
+--  Ref Constraints for Table BUILD_PLAN
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD CONSTRAINT "BUILD_PLAN_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."BUILD_PLAN" ADD CONSTRAINT "BUILD_PLAN_FK2" FOREIGN KEY ("RTAG_ID")
+	  REFERENCES "RELEASE_MANAGER"."RELEASE_TAGS" ("RTAG_ID") ON DELETE CASCADE ENABLE;
 --------------------------------------------------------
 --  Ref Constraints for Table BUILD_STANDARDS_ADDENDUM
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."BUILD_STANDARDS_ADDENDUM" ADD CONSTRAINT "BUILD_STANDARDS_ADDENDUM_R01" FOREIGN KEY ("BS_ID")
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" ADD FOREIGN KEY ("PV_ID")
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_BUILD_INFO" ADD FOREIGN KEY ("BM_ID")
 	  REFERENCES "RELEASE_MANAGER"."BUILD_MACHINES" ("BM_ID") ENABLE;
 --------------------------------------------------------
+--  Ref Constraints for Table PACKAGE_DEPENDENCIES
+--------------------------------------------------------
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD CONSTRAINT "PACKAGE_DEPENDENCIES_FK1" FOREIGN KEY ("PV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD CONSTRAINT "PACKAGE_DEPENDENCIES_FK2" FOREIGN KEY ("DPV_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD CONSTRAINT "PACKAGE_DEPENDENCIES_FK3" FOREIGN KEY ("DPKG_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ON DELETE CASCADE ENABLE;
+  ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DEPENDENCIES" ADD CONSTRAINT "PACKAGE_DEPENDENCIES_FK4" FOREIGN KEY ("PKG_ID")
+	  REFERENCES "RELEASE_MANAGER"."PACKAGES" ("PKG_ID") ON DELETE CASCADE ENABLE;
+--------------------------------------------------------
 --  Ref Constraints for Table PACKAGE_DOCUMENTS
 --------------------------------------------------------
   ALTER TABLE "RELEASE_MANAGER"."PACKAGE_DOCUMENTS" ADD CONSTRAINT "FK_PKGDOCS_REF_PV" FOREIGN KEY ("PV_ID")
 	  REFERENCES "RELEASE_MANAGER"."PACKAGE_VERSIONS" ("PV_ID") ENABLE;
   from DUAL;
 END;
+/
 ALTER TRIGGER "RELEASE_MANAGER"."TRIGGER_SDK_TAGS" ENABLE;
 --------------------------------------------------------
+--  DDL for Trigger TRIGGER_TEST_RUNS
+--------------------------------------------------------
+  CREATE OR REPLACE TRIGGER "RELEASE_MANAGER"."TRIGGER_TEST_RUNS"
+BEFORE INSERT ON TEST_RUN
+for each row
+BEGIN
+  select SEQ_TESTRUN_ID.nextval
+  into :new.TESTRUN_ID
+  from DUAL;
+END;
+/
+ALTER TRIGGER "RELEASE_MANAGER"."TRIGGER_TEST_RUNS" ENABLE;
+--------------------------------------------------------
 --  DDL for Function CAN_EDIT_PKG_IN_PROJECT
 --------------------------------------------------------
   CREATE OR REPLACE FUNCTION "RELEASE_MANAGER"."CAN_EDIT_PKG_IN_PROJECT" ( nPvId IN NUMBER, nRtagId IN NUMBER ) RETURN NUMBER IS
 -- Returns 0 : Package is not editable in this Release
   RETURN ret;
 END;
+/
+  GRANT EXECUTE ON "RELEASE_MANAGER"."GET_PV_FIRST_MODIFIED" TO "DM_READONLY";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."GET_PV_FIRST_MODIFIED" TO "RM_READONLY";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."GET_PV_FIRST_MODIFIED" TO "DEPLOYMENT_MANAGER";
 --------------------------------------------------------
 --  DDL for Function GET_V_EXT
 --------------------------------------------------------
   CREATE OR REPLACE FUNCTION "RELEASE_MANAGER"."GET_V_EXT" (SSpkg_version IN PACKAGE_VERSIONS.pkg_version%TYPE) RETURN VARCHAR2 IS
 	/*================================================================================================*/
 END PK_APP_UTILS;
+/
---------------------------------------------------------
---  DDL for Package PK_ARCHIVE
---------------------------------------------------------
-  CREATE OR REPLACE PACKAGE "RELEASE_MANAGER"."PK_ARCHIVE"
-IS
-/*
-------------------------------
-||  Author:  Rupesh Solanki
-||  Date:    26 October 2006
-||  Version:   1.0
-------------------------------
-*/
-   /*================================================================================================*/
-   PROCEDURE populate_packages_table;
-   PROCEDURE populate_archive_data_table (
-      nrtagid   IN   release_tags.rtag_id%TYPE
-   );
-   PROCEDURE migrate_pv_to_archive_SCHEMA (nrtagid IN release_tags.rtag_id%TYPE);
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_APP_UTILS" TO "DEPLOYMENT_MANAGER";
-   PROCEDURE migrate_rtag_to_archive_schema (
-      nrtagid   IN   release_tags.rtag_id%TYPE
-   );
-   PROCEDURE clean_up_archive_data_table (
-      nrtagid   IN   release_tags.rtag_id%TYPE
-   );
-   PROCEDURE write_action_log (
-      nuserid   IN   NUMBER,
-      nrtagid   IN   release_tags.rtag_id%TYPE
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_APP_UTILS" TO "CODE_INSPECTION";
-   );
-/*================================================================================================*/
-END pk_archive;
-/
 --------------------------------------------------------
 --  DDL for Package PK_BUILDAPI
 --------------------------------------------------------
   CREATE OR REPLACE PACKAGE "RELEASE_MANAGER"."PK_BUILDAPI"
       sactive                IN CHAR
    );
    /*================================================================================================*/
    PROCEDURE import_daemons ( nSourceRtagId IN NUMBER, nTargetRtagId IN NUMBER, nUserId IN NUMBER  );
    /*================================================================================================*/
-   PROCEDURE set_finite_pause (
+   PROCEDURE set_finite_pause ( duration IN NUMBER  );
-      duration IN NUMBER
+   PROCEDURE set_build_plan (rtagId IN NUMBER, nStartIndex IN NUMBER, pvList IN VARCHAR2);
-   );
 END pk_buildapi;
+/
 --------------------------------------------------------
    );
 /*================================================================================================*/
 END pk_package;
+/
+  GRANT EXECUTE, DEBUG ON "RELEASE_MANAGER"."PK_PACKAGE" TO "DEPLOYMENT_MANAGER";
+  GRANT EXECUTE, DEBUG ON "RELEASE_MANAGER"."PK_PACKAGE" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Package PK_PLANNED
 --------------------------------------------------------
   CREATE OR REPLACE PACKAGE "RELEASE_MANAGER"."PK_PLANNED" IS
 END pk_rmapi;
+/
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_RMAPI" TO "DM_READONLY";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_RMAPI" TO "MS_READONLY";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_RMAPI" TO "RM_EXTRACT_PV";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_RMAPI" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Package PK_WORK_IN_PROGRESS
 --------------------------------------------------------
   CREATE OR REPLACE PACKAGE "RELEASE_MANAGER"."PK_WORK_IN_PROGRESS" IS
 END;
 /*-------------------------------------------------------------------------------------------------------*/
 END PK_APP_UTILS;
+/
---------------------------------------------------------
---  DDL for Package Body PK_ARCHIVE
---------------------------------------------------------
-  CREATE OR REPLACE PACKAGE BODY "RELEASE_MANAGER"."PK_ARCHIVE"
-IS
-/*
-------------------------------
-||  Author:  Rupesh Solanki
-||  Date:    26 October 2006
-||  Version:   1.0
-------------------------------
-*/
-/*---------------------------*/
-PROCEDURE populate_packages_table IS
-BEGIN
-		  INSERT INTO archive_manager.PACKAGES
-		  (
-		  select * from packages where pkg_id not in
-		  		  (select pkg_id from archive_manager.packages)
-		  );
-          INSERT INTO archive_manager.PROCESSES
-          (
-          select * from processes where proc_id not in
-            (select proc_id from archive_manager.processes)
-          );
-END;
-/*-------------------------------------------------------------------------------------------------------*/
-   PROCEDURE populate_archive_data_table (
-      nrtagid   IN   release_tags.rtag_id%TYPE
-   )
-   IS
-/*
-Reason: To populate the archive_data table with information regarding the
-         number of package versions that exist in other releases.
-*/
-      numcount      NUMBER;
-      numusedby     NUMBER;
-      numruntime    NUMBER;
-      /* Get all the package versions in the release */
-      CURSOR archive_cur
-      IS
-         SELECT pv_id
-           FROM release_content
-          WHERE rtag_id = nrtagid;
-      archive_rec   archive_cur%ROWTYPE;
-   BEGIN
-/*--------------- Business Rules Here -------------------*/
-/*-------------------------------------------------------*/
-      OPEN archive_cur;
-      FETCH archive_cur
-       INTO archive_rec;
-      WHILE archive_cur%FOUND
-      LOOP
-        /* How many packages depend on this package version? */
-         SELECT COUNT (*)
-           INTO numusedby
-           FROM package_dependencies
-          WHERE dpv_id = archive_rec.pv_id;
-        /* How many project releases use this package version?  */
-         SELECT COUNT (*)
-           INTO numcount
-           FROM release_content
-          WHERE pv_id = archive_rec.pv_id;
-        /* How many packages have this package version as runtime
-        dependency? */
-         SELECT COUNT (*)
-           INTO numruntime
-           FROM runtime_dependencies
-          WHERE rtd_id = archive_rec.pv_id;
-        /* Insert into the archive_data table if they are not runtime dependant
-        and package dependant and they exist in that particular release only*/
-         IF numusedby = 0 AND numcount = 1 AND numruntime = 0
-         THEN
-            INSERT INTO archive_data
-                        (rtag_id, pv_id
-                        )
-                 VALUES (nrtagid, archive_rec.pv_id
-                        );
-         END IF;
-         FETCH archive_cur
-          INTO archive_rec;
-      END LOOP;
-   END;
-/*-------------------------------------------------------------------------------------------------------*/
-   PROCEDURE migrate_pv_to_archive_schema (
-      nrtagid   IN   release_tags.rtag_id%TYPE
-   )
-   IS
-   BEGIN
-      /* MIGRATION - PACKAGE_VERSIONS */
-      INSERT INTO archive_manager.package_versions
-         SELECT *
-           FROM package_versions
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* MIGRATION - PACKAGE_BUILD_ENV */
-      INSERT INTO archive_manager.package_build_env
-         SELECT *
-           FROM package_build_env
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM PACKAGE_BUILD_ENV */
-      DELETE FROM package_build_env
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - PACKAGE_BUILD_INFO */
-      INSERT INTO archive_manager.package_build_info
-         SELECT *
-           FROM package_build_info
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM PACKAGE_BUILD_info */
-      DELETE FROM package_build_info
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - UNIT_TESTS  */
-      INSERT INTO archive_manager.unit_tests
-         SELECT *
-           FROM unit_tests
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM UNIT_TESTS*/
-      DELETE FROM unit_tests
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - PACKAGE_PROCESSES */
-      INSERT INTO archive_manager.package_processes
-         SELECT *
-           FROM package_processes
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM PACKAGE_PROCESSES*/
-      DELETE FROM package_processes
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - PACKAGE_DEPENDENCIES */
-      INSERT INTO archive_manager.package_dependencies
-         SELECT *
-           FROM package_dependencies
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM PACKAGE_DEPENDENCIES*/
-      DELETE FROM package_dependencies
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - CODE_REVIEWS */
-      INSERT INTO archive_manager.code_reviews
-         SELECT *
-           FROM code_reviews
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM CODE_REVIEWS*/
-      DELETE FROM code_reviews
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - RUNTIME_DEPENDENCIES*/
-      INSERT INTO archive_manager.runtime_dependencies
-         SELECT *
-           FROM runtime_dependencies
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM RUNTIME_DEPENDENCIES*/
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_APP_UTILS" TO "DEPLOYMENT_MANAGER";
-      DELETE FROM runtime_dependencies
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - PACKAGE_DOCUMENTS */
-      INSERT INTO archive_manager.package_documents
-         SELECT *
-           FROM package_documents
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM PACKAGE_DOCUMENTS*/
-      DELETE FROM package_documents
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - PACKAGE_PATCHES */
-      INSERT INTO archive_manager.package_patches
-         SELECT *
-           FROM package_patches
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM PACKAGE_PATCHES*/
-      DELETE FROM package_patches
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - CQ_ISSUES */
-      INSERT INTO archive_manager.cq_issues
-         SELECT *
-           FROM cq_issues
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM CQ_ISSUES*/
-      DELETE FROM cq_issues
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - ADDITIONAL_NOTES */
-      INSERT INTO archive_manager.additional_notes
-         SELECT *
-           FROM additional_notes
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM ADDITIONAL_NOTES*/
-      DELETE FROM additional_notes
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - RELEASE_COMPONENTS */
-      INSERT INTO archive_manager.release_components
-         SELECT *
-           FROM release_components
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM RELEASE_COMPONENTS*/
-      DELETE FROM release_components
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - IGNORE_WARNINGS */
-      INSERT INTO archive_manager.ignore_warnings
-         SELECT *
-           FROM ignore_warnings
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM IGNORE_WARNINGS*/
-      DELETE FROM ignore_warnings
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* PURGE DATA FROM WORK_IN_PROGRESS */
-      DELETE FROM work_in_progress
-            WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM PLANNED */
-      DELETE FROM planned
-            WHERE rtag_id = nrtagid;
-      /* MIGRATION - JIRA_ISSUES */
-      INSERT INTO archive_manager.jira_issues
-         SELECT *
-           FROM jira_issues
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM JIRA_ISSUES*/
-      DELETE FROM jira_issues
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - PRODUCT_COMPONENTS */
-      INSERT INTO archive_manager.product_components
-         SELECT *
-           FROM product_components
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM PRODUCT_COMPONENTS*/
-      DELETE FROM product_components
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-      /* MIGRATION - ACTION_LOG */
-      INSERT INTO archive_manager.action_log
-         SELECT *
-           FROM action_log
-          WHERE pv_id IN (SELECT pv_id
-                            FROM archive_data);
-      /* PURGE DATA FROM ACTION_LOG*/
-      DELETE FROM action_log
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-   END;
-/*-------------------------------------------------------------------------------------------------------*/
-   PROCEDURE migrate_rtag_to_archive_schema (
-      nrtagid   IN   release_tags.rtag_id%TYPE
-   )
-   IS
-   BEGIN
-      /* MIGRATION - DO_NOT_RIPPLE */
-      INSERT INTO archive_manager.do_not_ripple
-         SELECT *
-           FROM do_not_ripple dnp
-          WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM DO_NOT_RIPPLE */
-      DELETE FROM do_not_ripple
-            WHERE rtag_id = nrtagid;
-      /* MIGRATION - ADVISORY_RIPPLES*/
-      INSERT INTO archive_manager.advisory_ripples
-         SELECT *
-           FROM advisory_ripple dnp
-          WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM ADVISORY_RIPPLES*/
-      DELETE FROM advisory_ripple
-            WHERE rtag_id = nrtagid;
-      /* MIGRATION - RELEASE_CONTENT */
-      INSERT INTO archive_manager.release_content
-         SELECT *
-           FROM release_content
-          WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM RELEASE_CONTENT*/
-      DELETE FROM release_content
-            WHERE rtag_id = nrtagid;
-      /* MIGRATION - NOTIFICATION_HISTORY */
-      INSERT INTO archive_manager.notification_history
-         SELECT *
-           FROM notification_history
-          WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM NOTIFICATION_HISTORY*/
-      DELETE FROM notification_history
-            WHERE rtag_id = nrtagid;
-      /* MIGRATION - BUILD_ORDER   */
-      INSERT INTO archive_manager.build_order
-         SELECT *
-           FROM build_order
-          WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM BUILD_ORDER*/
-      DELETE FROM build_order
-            WHERE rtag_id = nrtagid;
-      /* MIGRATION - PROJECT_ACTION_LOG */
-      INSERT INTO archive_manager.project_action_log
-         SELECT *
-           FROM project_action_log
-          WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM PROJECT_ACTION_LOG */
-      DELETE FROM project_action_log
-            WHERE rtag_id = nrtagid;
-      /* MIGRATION - DEPRECATED_PACKAGES */
-      INSERT INTO archive_manager.deprecated_packages
-         SELECT *
-           FROM deprecated_packages
-          WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM DEPRECATED_PACKAGES */
-      DELETE FROM deprecated_packages
-            WHERE rtag_id = nrtagid;
-      /* MIGRATION - RELEASE_TAGS */
-      INSERT INTO archive_manager.release_tags
-         SELECT *
-           FROM release_tags
-          WHERE rtag_id = nrtagid;
-      /* PURGE DATA FROM PACKAGE_VERSIONS*/
-      DELETE FROM package_versions
-            WHERE pv_id IN (SELECT pv_id
-                              FROM archive_data);
-   END;
-/*-------------------------------------------------------------------------------------------------------*/
-   PROCEDURE clean_up_archive_data_table (
-      nrtagid   IN   release_tags.rtag_id%TYPE
-   )
-   IS
-   BEGIN
-      /* Cleaning Up The Archive_Data Table */
-      DELETE FROM archive_data
-            WHERE rtag_id = nrtagid;
-   END;
-/*-------------------------------------------------------------------------------------------------------*/
-   PROCEDURE write_action_log (
-      nuserid   IN   NUMBER,
-      nrtagid   IN   release_tags.rtag_id%TYPE
-   )
-   IS
-   BEGIN
-      /* Write Into Archive_Action_Log Table */
-      INSERT INTO archive_action_log
-                  (user_id, date_time_stamp, rtag_id,
-                   description
-                  )
-           VALUES (nuserid, ora_sysdatetime, nrtagid,
-                   'Release has been archived to the ARCHIVE_MANAGER schema'
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_APP_UTILS" TO "CODE_INSPECTION";
-                  );
-   END;
-/*-------------------------------------------------------------------------------------------------------*/
-END pk_archive;
-/
 --------------------------------------------------------
 --  DDL for Package Body PK_BUILDAPI
 --------------------------------------------------------
   CREATE OR REPLACE PACKAGE BODY "RELEASE_MANAGER"."PK_BUILDAPI"
     WHERE rt.RTAG_ID = nTargetRtagId;
    Log_Project_Action ( ProjId, 'import_daemon_configuration', nUserId, 'SOURCE: '|| sSourceLocation ||'   TARGET: '|| sTargetLocation, nTargetRtagId );
 END;
+/*-------------------------------------------------------------------------------------------------------*/
+PROCEDURE set_build_plan (rtagId IN NUMBER, nStartIndex IN NUMBER, pvList IN VARCHAR2)
+   IS
+    nPvIdCollector RELMGR_NUMBER_TAB_t := RELMGR_NUMBER_TAB_t();
+    SeqNum NUMBER;
+   BEGIN
+   -- Remove all the old entries, on first usage
+   IF nStartIndex = 0 then
+    DELETE BUILD_PLAN WHERE RTAG_ID = rtagId;
+    SeqNum := 0;
+   ELSE
+    SELECT COUNT(*) into SeqNum from BUILD_PLAN WHERE RTAG_ID = rtagId;
+   END IF;
+   -- Set start sequence number
+   nPvIdCollector := IN_LIST_NUMBER ( pvList );
+   FOR i IN 1..nPvIdCollector.COUNT
+   LOOP
+      -- Update build plan with order
+      INSERT INTO BUILD_PLAN (RTAG_ID, BUILD_ORDER, PV_ID) VALUES (rtagId, SeqNum, nPvIdCollector(i));
+      SeqNum := SeqNum + 1;
+   END LOOP;
+END;
 END pk_buildapi;
+/
 --------------------------------------------------------
 --  DDL for Package Body PK_ENVIRONMENT
             INSERT INTO package_versions(pv_id, pkg_id, pkg_version, dlocked, created_stamp,
                                          creator_id, modified_stamp, modifier_id, v_mm, v_nmm,
                                          v_ext, src_path, pv_description, pv_overview,
                                          last_pv_id, owner_id, is_deployable,
                                          is_build_env_required, build_type, change_type,
-                                         bs_id, is_autobuildable, ripple_field)
+                                         bs_id, is_autobuildable, ripple_field, build_time)
                  SELECT returnpvid AS pv_id, origpkg_id AS pkg_id,
                         spackageversion AS pkg_version, 'N' AS dlocked,
                         ora_sysdate AS created_stamp, nuserid AS creator_id,
                         ora_sysdatetime AS modified_stamp,
                         nuserid AS modifier_id, ssv_mm AS v_mm,
                         ssv_nmm AS v_nmm, ssv_ext AS v_ext, pv.src_path,
                         pv.pv_description, pv.pv_overview,
                         nlastpvid AS last_pv_id, pv.owner_id, pv.is_deployable,
                         pv.is_build_env_required, cbuildtype, uchangetype,
-                        pv.bs_id, pv.is_autobuildable, pv.ripple_field
+                        pv.bs_id, pv.is_autobuildable, pv.ripple_field, pv.build_time
                    FROM package_versions pv
                   WHERE pv.pv_id = nlastpvid;
             -- Set Issues Type for cloning ---
             IF origdlocked = 'Y'
          IF LOCKED = 'Y'
          THEN
             problemstring :=
                   problemstring
                || '- Package is locked and released.'
-               || UTL_TCP.crlf;
+               ||PK_PACKAGE.crlf;
          END IF;
          -- Cannot remove if used in BOMs
          SELECT COUNT (osc.prod_id)
            INTO ROWCOUNT
          IF ROWCOUNT > 0
          THEN
             problemstring :=
                   problemstring
                || '- Package is part of Bill-Of-Material (BOM) in Deployment Manager.'
-               || UTL_TCP.crlf;
+               ||PK_PACKAGE.crlf;
          END IF;
          -- Cannot remove if Referenced as build dependency
          SELECT COUNT (dep.pv_id)
            INTO ROWCOUNT
          IF ROWCOUNT > 0
          THEN
             problemstring :=
                   problemstring
                || '- Package is referenced by other package as build dependency.'
-               || UTL_TCP.crlf;
+               ||PK_PACKAGE.crlf;
          END IF;
          -- Cannot remove if Referenced as runtime dependency
          SELECT COUNT (rd.pv_id)
            INTO ROWCOUNT
          IF ROWCOUNT > 0
          THEN
             problemstring :=
                   problemstring
                || '- Package is referenced by other package as runtime dependency.'
-               || UTL_TCP.crlf;
+               ||PK_PACKAGE.crlf;
          END IF;
          -- Cannot remove if Referenced as patch
          SELECT COUNT (pp.pv_id)
            INTO ROWCOUNT
          IF ROWCOUNT > 0
          THEN
             problemstring :=
                   problemstring
                || '- Package is used as patch by other package.'
-               || UTL_TCP.crlf;
+               ||PK_PACKAGE.crlf;
          END IF;
       END IF;
 /*-------------------------------------------------------*/
       IF (problemstring IS NULL)
    END;
 /*-------------------------------------------------------------------------------------------------------*/
 END pk_package;
+/
+  GRANT EXECUTE, DEBUG ON "RELEASE_MANAGER"."PK_PACKAGE" TO "DEPLOYMENT_MANAGER";
+  GRANT EXECUTE, DEBUG ON "RELEASE_MANAGER"."PK_PACKAGE" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Package Body PK_PLANNED
 --------------------------------------------------------
   CREATE OR REPLACE PACKAGE BODY "RELEASE_MANAGER"."PK_PLANNED" IS
 END;
    END;
+/
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_RMAPI" TO "DM_READONLY";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_RMAPI" TO "MS_READONLY";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_RMAPI" TO "RM_EXTRACT_PV";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."PK_RMAPI" TO "RM_READONLY";
 --------------------------------------------------------
 --  DDL for Package Body PK_WORK_IN_PROGRESS
 --------------------------------------------------------
   CREATE OR REPLACE PACKAGE BODY "RELEASE_MANAGER"."PK_WORK_IN_PROGRESS" IS
     CLOSE package_versions_cur;
 END Seed_Package_Names_Versions;
+/
+  GRANT EXECUTE ON "RELEASE_MANAGER"."SEED_PACKAGE_NAMES_VERSIONS" TO "DEPLOYMENT_MANAGER";
+  GRANT EXECUTE ON "RELEASE_MANAGER"."SEED_PACKAGE_NAMES_VERSIONS" TO "CODE_INSPECTION";
 --------------------------------------------------------
 --  DDL for Procedure SET_ADVISORY_RIPPLE
 --------------------------------------------------------
 set define off;

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/web/database/Relman_export.sql – Rev 5506 → 5892