define targuser=bergerone
define proxyuser=irscis

prompt enter pwd : &&targ_pwd

create user &&targuser identified by &&targ_pwd ;
alter user &&proxyuser grant connect through &&targuser;
conn &&targuser[&&proxyuser]/&&targ_pwd;

--select * from dba_proxies;