Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using PROXY authentication with OS externally identified users

user537135Mar 1 2013 — edited Mar 4 2013
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2013
Added on Mar 1 2013
2 comments
207 views