connect &1/&2@&5 as sysdba

drop user &3 cascade;

grant connect, resource to &3 identified by &4;
grant create view, create any directory to &3;
grant create library to &3;
grant debug connect session, javauserpriv to &3;
grant execute on dbms_sql to &3;
grant create procedure  to &3;
grant execute on plpdf.plpdf to &3;
grant execute on plpdf.plpdf_img to &3;

create synonym &3..plpdf for plpdf.plpdf;
create synonym &3..plpdf_img for plpdf.plpdf_img;
create synonym &3..plpdf_type for plpdf.plpdf_type;

connect &3/&4@&5

@@mip.sql
@@mipDirectories.sql
@@mipExtTables.sql
@@gtt_dir_list.pdc
@@mipViews.sql
@@mipLibraries.sql

exit
