-- 1. 以DBA身份连接至数据库,创建一个代理用户,授予权限。
SQL> create user dbproxy identified by dbproxy;
User created.
SQL> grant connect to dbproxy;
Grant succeeded.
-- 2. 使目标用户可以通过代理用户切换
SQL> alter user jly grant connect through dbproxy;
User altered.
-- 3. 登录测试
SQL> conn dbproxy[jly]/dbproxy
Connected.
SQL> show user
USER is "JLY"