proxy connection question
Hello I can't seem to get syntax correct for connecting thru a Proxy using username and password.
user : test1/test1
proxy : uwg_proxy/proxypass
alter user test1
grant connect through uwg_proxy
authenticated using password;
SQL> connect test1/test1@xxxx;
Connected.
SQL> connect uwg_proxy/proxypass@xxxx;
Connected.
SQL> connect uwg_proxy[test1]/proxypass@xxxx;
ERROR:
ORA-28150: proxy not authorized to connect as client
Warning: You are no longer connected to ORACLE.
SQL> connect uwg_proxy[test1]/test1@xxxx;
ERROR:
ORA-01017: invalid username/password; logon denied
please help.
Thanks,
Bill