-- step1.sql
set linesize 500
set pagesize 0
SET HEADING OFF ECHO OFF FEEDBACK OFF
set serveroutput on size 1000000
alter session set max_dump_file_size=unlimited;
ALTER session SET timed_statistics = true; 
exec DBMS_OUTPUT.ENABLE(1000000) ;
alter session set STATISTICS_LEVEL = ALL ;
WHENEVER SQLERROR CONTINUE NONE 
-- needed grant any role, grant any prvilege to connected user
DROP USER &2 CASCADE ;
CREATE USER &2 IDENTIFIED by &3 TEMPORARY TABLESPACE &5 DEFAULT TABLESPACE &4 ;
GRANT CONNECT, RESOURCE, ALTER session TO &2 ;
--