Re: Sqlplus env variable?

I did not succeed in setting such a variable. All I could do was setting TWO_TASK to the connect string.

But if you want to avoid the ps listing showing the username and password you can write it as the first line in your sqlplus script and start that script when invoking sqlplus. The following worked for me:

testus/testus_at_db_2
-- Script passtest.sql must start with username/pw_at_connstring select user from dual;
exit

Martin Haltmayer

rwp wrote:
>
> Anyone know if it's possible to define a unix environment variable that
> contains username/password for sqlplus so that all you have to do is
> execute the sqlplus command. For example:
>
> VARIABLE="username/password"
> sqlplus <Return>
>
> I know I can use the OPS$ accounts to prevent username/password from
> showing up in a unix "ps" list but I have a need to do this with several
> oracle accounts from one unix account and don't want the password to be
> visible from the "ps" unix command. Any ideas?
>
> rwp.
  Received on Thu Mar 05 1998 - 00:00:00 CST