创建代理用户连接数据库

orcl@SYS > create user jerry identified by jerry;

orcl@SYS > grant connect,resource to 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