proxy connection question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: proxy connection question

Hybrid View

  1. #1
    Join Date
    Oct 2008
    Posts
    2

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    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.

  3. #3
    Join Date
    Oct 2008
    Posts
    2
    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
  •  



Click Here to Expand Forum to Full Width