Fixed privileged for UT3_OWNER.

jgebal · jgebal · commit 73935594eada · 2017-01-21T17:50:29.000Z
diff --git a/docs/userguide/install.md b/docs/userguide/install.md
@@ -24,7 +24,7 @@ The installation user/schema must have the following Oracle system permissions d
   
 In addition it must be granted execute to the following system packages.
 
-  - DBMS_PIPE  
+  - DBMS_LOCK  
   
 # Installation Procedure
 
diff --git a/source/create_utplsql_owner.sql b/source/create_utplsql_owner.sql
@@ -13,7 +13,7 @@ create user &ut3_user identified by &ut3_password default tablespace &ut3_tables
 
 grant create session, create sequence, create procedure, create type, create table, create synonym to &ut3_user;
 
-grant execute on dbms_pipe to &ut3_user;
+grant execute on dbms_lock to &ut3_user;
 
 grant alter session to &ut3_user;
 
diff --git a/source/install.sql b/source/install.sql
@@ -202,7 +202,7 @@ column error_count noprint new_value error_count
 prompt Validating installation
 select name, type, sequence, line, position, text, count(1) over() error_count
   from all_errors
- where owner = '&&ut3_owner'
+ where owner = upper('&&ut3_owner')
    and name not like 'BIN$%'  --not recycled
    and (name = 'UT' or name like 'UT\_%' escape '\')
    -- errors only. ignore warnings
