Thursday, December 07, 2006

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.

No comments:

I am well fed with these !!