Pro*C - Connect to a Oracle Database without password

From: Santiago Gil-Cepeda Morán <s.gilcepeda_at_mju.es>
Date: 19 Jun 2002 01:41:35 -0700
Message-ID: <bdc005a1.0206190041.4029fba7_at_posting.google.com>



Hello,

[Quoted] 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]

[Quoted] 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. Received on Wed Jun 19 2002 - 10:41:35 CEST

Original text of this message