-
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
-
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|