Added back grant administer database trigger to &&ut3_owner;

jgebal · jgebal · commit b21dbaac80ed · 2019-06-20T00:16:51.000+01:00
This is only needed for the duration of the install process.
We also re-enable this privilege to allow for tests to disable/enable trigger.
diff --git a/.travis/install.sh b/.travis/install.sh
@@ -63,6 +63,10 @@ time "$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
 set feedback off
 whenever sqlerror exit failure rollback
 
+--------------------------------------------------------------------------------
+PROMPT Adding back create-trigger privilege to $UT3_OWNER for testing
+grant administer database trigger to $UT3_OWNER;
+
 --------------------------------------------------------------------------------
 PROMPT Creating $UT3_TESTER - Power-user for testing internal framework code
 
diff --git a/source/install_ddl_trigger.sql b/source/install_ddl_trigger.sql
@@ -18,5 +18,7 @@
 @@define_ut3_owner_param.sql
 
 @@check_sys_grants.sql "'ADMINISTER DATABASE TRIGGER','CREATE TRIGGER'"
-@@install_component.sql 'core/annotations/ut_trigger_annotation_parsing.trg'
 
+grant administer database trigger to &&ut3_owner;
+@@install_component.sql 'core/annotations/ut_trigger_annotation_parsing.trg'
+revoke administer database trigger from &&ut3_owner;
diff --git a/source/install_headless_with_trigger.sql b/source/install_headless_with_trigger.sql
@@ -21,6 +21,6 @@
 @@install.sql &&ut3_owner
 @@create_synonyms_and_grants_for_public.sql &&ut3_owner
 
-@@install_ddl_trigger.sql
+@@install_ddl_trigger.sql &&ut3_owner
 
 exit
