2 Replies Latest reply: Mar 4, 2013 12:00 PM by user537135 RSS

    Using PROXY authentication with OS externally identified users

    user537135
      I was hoping to be able to use PROXY authentication with OS externally identified user in order to run scripts on the database server that need to connect to different accounts without providing passwords. It looks like this is not possible? The only way I can get connect to work is if I also give a password to the OPS$ account. Providing just "/" as the account gives an error. Is there any way to get this to work or are PROXY connections not permitted with OS EXTERNALLY identified accounts and no password?

      SQL> select user from dual;

      USER
      ------------------------------
      OPS$ORACLE

      SQL> alter user rgdh grant connect through ops$oracle;

      User altered.

      SQL> connect /[rgdh]
      SP2-0306: Invalid option.
      Usage: CONN[ECT] [logon [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]
      where <logon> ::= <username>[<password>][@<connect_identifier>]
      <proxy> ::= <proxyuser>[<username>][<password>][@<connect_identifier>]


      SQL> connect ops$oracle[rgdh]
      Enter password: providepassword
      Connected.

      SQL> select user from dual;

      USER
      ------------------------------
      RGDH