Shell Programming and Scripting

Hello,

I need to know that whether a content of a string can be hidden or masked inside a shell script.

My Sample Code is given below

<Code>
#!/usr/bin/ksh
Userid=test
DB=temp
Passwd=`java Decryption test`
# The Above command will get the encryped password for "test" user id and store it in Passwd Variable.
# I donot want anybody to see the Value of Passwd even if it is echoed on the screen. (ie) Either by masking or hiding.
# I want to connect to a DB by passing the Passwd Vairable
CONN=`sqlplus -s $Userid/$Passwd@DB <<EOF
whenever sqlerror exit failure
select * from dual;
EOF`
echo "CONN : "$CONN
</Code>

Can anybody help me on this.

Thanks

Rahul

This question has been answered many times in many forums. Suggest you do a Web search for "oracle hide username password"

Code:

/oracle/app/oracle/product/9.2.0.1/bin/sqlplus -S /nolog <<END_SQL
connect $LOGON
(Rest of SQL)
exit
END_SQL

Pattern after this, we had the same problem.

Do the connect within the SQL - in our case LOGON contains the login information - then run the rest of the sql.