How do I prevent the password from being displayed by the ps command?
On some UNIX platforms and in some versions, isql for UNIX allows the password to be displayed when you run the ps command. Newer versions of isql try to write over the password string so that it is not visible in ps. However, depending on how the operating system stores the password string, this strategy may not be successful. The password is revealed in the ps output only in cases where isql is started with the password in the command line. Some ways to avoid putting the password in the command line are described below. • Use the command line option -i rather than the shell redirect (<). isql then displays the "password:" prompt. % isql -U login -i input.sql -o output.out Password: password • Write a script like this example. Put the password in the first line that isql receives from standard input. isql -U login << EOF password use database go sp_help go quit EOF • Echo the password and pipe it into isql.
