passing password to isql in a shell script

[mohanx]

am using isql with -i option to execute a query.this is in a shell script. i want to know the various options of passing the password keeping in mind the issue of other users not able to "see" the password.

[harry d brown jr]

Write a "c" program to start it, embed the passwd - encrypted, and when you execute the program decrypt it and pass it to isql.

live free or die
harry

[Deepak Extross]

Why do you need to pass a password to isql?
The following query should work:
isql -s database_name << EOF

EOF

As long as the user-id of the person running this query has appropriate permissions on the database, no password should be necessary.

[James Beamish-White]

There is also a tool out there called Expect. It responds to 'expected' prompts with whatever you want it to. Have a search on the web for it.

Cheers,
James