orcl@SYS > create user jerry identified by jerry;
orcl@SYS > create user proxy identified by proxy;
User created.
orcl@SYS > grant connect to proxy;
Grant succeeded.
orcl@SYS > alter user jerry grant connect through proxy;
User altered.
orcl@SYS > conn proxy[jerry]/proxy;
Connected.
orcl@JERRY > show user;
USER is "JERRY"
orcl@JERRY > select * from session_privs;
PRIVILEGE
--------------------------------------------------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
CREATE CLUSTER
CREATE SEQUENCE
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE
10 rows selected.
orcl@JERRY > conn proxy/proxy
Connected.
orcl@PROXY > select * from session_privs;
PRIVILEGE
--------------------------------------------------------------------------------
CREATE SESSION