Proxy authentication to Oracle Database

Interesting post on proxy authentication.

OraTransplant - Wilfred van der Deijl » Using Proxy Authentication with SQLPlus

it took me few extra steps to test this.

• logged into ORACLE 10.2 db instance using sqlplus as dba and executed following sql statements.

1. CREATE USER proxy IDENTIFIED AS proxy;
2. GRANT CREATE SESSION TO proxy;
3. ALTER USER proxy GRANT CONNECT THROUGH scott;
   

• now login as scott[proxy]/tiger

as simple as that.