proxy connection question

[bigdogbill]

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

[davey23uk]

ORA-28150: proxy not authorized to connect as client
Cause: A proxy user attempted to connect as a client, but the proxy was not authorized to act on behalf of the client.
Action: Grant the proxy user permission to perform actions on behalf of the client by using the ALTER USER ... GRANT CONNECT command.

[bigdogbill]

Thanks Davey23uk but if you do that then it negates the previous

alter user test1 grant connect through uwg_proxy authenticted using pasword;

I need to have the proxied user supply botht the username and the users database password.

Out of the 4 proxy authentication modes i'm choosing proxy by providing the user name and password.

thanks
Bill