Hided output table under view to be EBR-ready

Pazus · Pazus · commit af26d830a7f4 · 2017-02-26T13:58:46.000+03:00
diff --git a/docs/userguide/install.md b/docs/userguide/install.md
@@ -19,6 +19,7 @@ The installation user/schema must have the following Oracle system permissions d
   - CREATE PROCEDURE
   - CREATE TYPE
   - CREATE TABLE
+  - CREATE VIEW
   - CREATE SYNONYM
   - ALTER SESSION
   
diff --git a/source/core/ut_output_buffer_tmp.sql b/source/core/ut_output_buffer_tmp.sql
@@ -1,4 +1,4 @@
-create table ut_output_buffer_tmp(
+create table ut_output_buffer_tmp$(
   /*
   utPLSQL - Version X.X.X.X
   Copyright 2016 - 2017 utPLSQL Project
@@ -27,4 +27,37 @@ create table ut_output_buffer_tmp(
 ) nologging nomonitoring initrans 100
 ;
 
-create index ut_output_buffer_tmp_i on ut_output_buffer_tmp(start_date) initrans 100 nologging;
+create index ut_output_buffer_tmp_i on ut_output_buffer_tmp$(start_date) initrans 100 nologging;
+
+-- This is needed to be EBR ready as editioning view can only be created by edition enabled user
+declare
+  ex_nonedition_user exception;
+  ex_view_doesnt_exist exception;
+  pragma exception_init(ex_nonedition_user,-42314);
+  pragma exception_init(ex_view_doesnt_exist,-942);
+begin
+  begin
+    execute immediate 'drop view ut_output_buffer_tmp';
+  exception
+    when ex_view_doesnt_exist then
+      null;
+  end;
+  
+  execute immediate 'create or replace editioning view ut_output_buffer_tmp as
+select reporter_id
+      ,message_id
+      ,text
+      ,is_finished
+      ,start_date
+  from ut_output_buffer_tmp$';
+exception 
+  when ex_nonedition_user then
+    execute immediate 'create or replace view ut_output_buffer_tmp as
+select reporter_id
+      ,message_id
+      ,text
+      ,is_finished
+      ,start_date
+  from ut_output_buffer_tmp$';
+end;
+/
diff --git a/source/create_utplsql_owner.sql b/source/create_utplsql_owner.sql
@@ -27,7 +27,7 @@ define ut3_tablespace = &3
 
 create user &ut3_user identified by &ut3_password default tablespace &ut3_tablespace quota unlimited on &ut3_tablespace;
 
-grant create session, create sequence, create procedure, create type, create table, create synonym to &ut3_user;
+grant create session, create sequence, create procedure, create type, create table, create view, create synonym to &ut3_user;
 
 grant execute on dbms_lock to &ut3_user;
 
