Re: Pro*C - Connect to a Oracle Database without password
Date: 19 Jun 2002 05:07:28 -0700
Message-ID: <aeps600mtt_at_drn.newsguy.com>
In article <bdc005a1.0206190041.4029fba7_at_posting.google.com>, s.gilcepeda_at_mju.es
says...
>
>Hello,
>
>I have developed some shellscripts which call Pro*C programs to
>connect to Oracle Database (Oracle 7.3.4 and Oracle 8.1.7) to execute
>a selects. In my production enviroment, I have to install those
>shellscripts in several servers with several Oracle schemas and
>passwords.
>
>My operating systems are HP-UX 10.20-11.00 and Linux Red Hat 7.2.
>
>My question is how can I connect to an Oracle user to execute a
>"select" using Pro*C, without using the password. I know that Oracle
>lets me create an OPS user to let a Unix user access to a Oracle user
>(using sqlplus) without password. This is the sentence:
>
>create user ops$[unix_user] identified externally
>grant connect to ops$[unix_user]
yes, just
exec sql connect :userid;
and have userid = "/"
>
>Is it possible to do something similar to execute a Proc*C program
>with a Unix user and connect to an Oracle user, without using a
>password?
>
>Thanks in advance!
>
>Best regards.
-- Thomas Kyte (tkyte_at_oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Wed Jun 19 2002 - 14:07:28 CEST