rem
rem This script can be used to grant the required roles and privileges
rem to a Target User which is to be used for Upgrade Deployment actions.
rem
rem USAGE
rem This script must be run in the Database SYS account
rem    
rem    @<OWB-HOME>/owb/rtp/sql/grant_upgrade_privileges.sql <username>
rem

set serveroutput on;
set verify off;

grant 'CONNECT' to &1.;
grant 'SELECT_CATALOG_ROLE' to &1.;

grant CREATE TRIGGER to &1.;
grant CREATE PROCEDURE to &1.;
grant EXECUTE ANY PROCEDURE to &1.;
grant CREATE TYPE to &1.;
grant EXECUTE ANY TYPE to &1.;
grant SELECT ANY TABLE to &1.;
grant SELECT ANY DICTIONARY to &1.;