whenever sqlerror exit failure rollback whenever oserror exit failure rollback set echo off set verify off define UTPLSQL_USER = 'UT3'; define APP_USER = 'APP'; define CODE_OWNER = 'CODE_OWNER'; define TESTS_OWNER = 'TESTS_OWNER'; define DB_PASS = 'pass'; grant execute any procedure to &UTPLSQL_USER; grant create any procedure to &UTPLSQL_USER; grant execute on dbms_lob to &UTPLSQL_USER; grant execute on dbms_sql to &UTPLSQL_USER; grant execute on dbms_xmlgen to &UTPLSQL_USER; grant execute on dbms_lock to &UTPLSQL_USER; create user &APP_USER identified by &DB_PASS quota unlimited on USERS default tablespace USERS; grant create session, create procedure, create type, create table, create sequence, create view to &APP_USER; grant select any dictionary to &APP_USER; create user &CODE_OWNER identified by &DB_PASS quota unlimited on USERS default tablespace USERS; grant create session, create procedure, create type, create table, create sequence, create view to &CODE_OWNER; create user &TESTS_OWNER identified by &DB_PASS quota unlimited on USERS default tablespace USERS; grant create session, create procedure, create type, create table, create sequence, create view, create synonym to &TESTS_OWNER; grant select any dictionary to &TESTS_OWNER; grant select any table, delete any table, drop any table to &TESTS_OWNER; grant execute any procedure to &TESTS_OWNER;