ORACE PROXY USER

PROXY USER
============

create user proxy identified by proxy Default tablespace "USR" temporary tablespace "TEMPORARY" account unlock profile "DEFAULT";
grant create session,resource  to proxy;            

create user vinay identified by vinay Default tablespace "USR" temporary tablespace "TEMPORARY" account unlock profile "DEFAULT";
grant create session, create table,resource to vinay;
grant firmpermission,remoteuser to vinay with admin option;            

create user mayank identified by mayank Default tablespace "USR" temporary tablespace "TEMPORARY" account unlock profile "DEFAULT";
grant create session, create table,resource to vinay;
grant firmpermission,remoteuser to vinay with admin option;            

alter user vinay grant connect through proxy;
alter user vinay quota unlimited on USR;            

alter user mayank grant connect through proxy;
alter user mayank quota unlimited on USR;            

create table end_user.tableX(col1 number);            

connect proxy[vinay]/proxy@alm1112srv

select user from dual;
desc tableX