Re: Develop Shell Script - hiding database password

From: Sreejith Nair <sreejithsna_at_gmail.com>
Date: Thu, 28 Jul 2011 07:39:31 +0530
Message-ID: <1269447072.996305971_at_gmail.com>

We used Oracle wallet / Oracle external password store to hide password. This let's you to take a connection in your shell scripts as 'sqlplus /_at_MYDB' where MYDB is an alias to your connection which is stored in wallet and resolved in tnsnames.ora.

Cheers,
Sreejith

• Original message -------
  > From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
  > To: oracle-l_at_freelists.org
  > Sent: 28/7/'11, 6:06
  >
  > Hi Friends, 
  >
  > I have to write a script shell to do a connection on the Oracle Database, execute a sql statment and generates a formated output file delimited by a specific separator.
  > My issue is: What's the best way to hide the Database's password ?
  >
  > Regards,
  > Eriovaldo.
  

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 27 2011 - 21:09:31 CDT