Re: Pro*C - Connect to a Oracle Database without password

From: Thomas Kyte <tkyte_at_oracle.com>
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 Corp 
Received on Wed Jun 19 2002 - 14:07:28 CEST

Original text of this message