Proxy User and Connect Through

Assuming we have a user called CHIUP and we want to connect to LIB1 without knowing the password, we could do the following.

P.S. This method works for Forms 12c but not Forms 10g.

As DBA

ALTER USER LIB1 GRANT CONNECT THROUGH CHIUP;

Connect via SQL*Plus

CONN CHIUP[LIB1]/xxxxxxx

Connect via SQL Developer
Hit "Advanced..." button in the connection setup window


Revoke Access
As DBA

ALTER USER LIB1 REVOKE CONNECT THROUGH CHIUP;