Hi EverB,
I am writing a shell script which logs into database and do some processing.The userid and passwd to log into the database is given as a parameter.

The problem is when u ececute ps -ef|grep -i scriptname,
it reveals the username and pwd which i want to avoid.
How can i achieve this.

Thanks in Advance ,
Arun

as an FYI:
http://www.bijoos.com/oratom/ot_199909.htm

A very easy way to do that is declaring the username and the password as an environment variable.

Let me know if you need more help,
Thanks.

JIM.

yeeah, could be a bit more specific and post a sample code, pls.

Other ways to 'hide' the userid/password are:
1) execute sqlplus with /nolog option:

Code:

sqlplus /nolog <<!EOF
connect <uid>/<pw>
@MyScript
exit
!EOF

2) Invoke sqlplus with the userid only and supply the password on first line:

Code:

sqlplus <userid> <<!EOF
<pw>
@MyScript
exit
!EOF

3) Create an 'externally identified user:

Code:

CREATE USER OPS$THEOPR IDENTIFIED EXTERNALLY ...etc

and when you logon to the server with user THEOPR, just execute sqlplus like this:

Code:

sqlplus / ...

Note: THEOPR must be a unix user-id and the 'OPS$' is the value of the 'os_authent_prefix' init.ora parameter.