Re: Sqlplus env variable?

Well, you could create a directory with a long name and link sqlplus to $ORACLE-HOME/BIN/sqlplus and do a

/export/home/dsceng/application_name/usr\/bin/\ a_really_really_long_directory_name_to_hide_oracle_passwords/sqlplus \ $_apppw @app.sql

(\) added to break line.

rwp (randy_prater_at_ibm.net) 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.

--
While DSC may claim ownership of all my ideas (on or off the job),
DSC does not claim any responsibility for them. Warranty expired when you
opened this article and I will not be responsible for its contents or use.