Hiding your password to isql

Single ASE on host

• Script #1

Assuming that you are using bourne shell sh(1) as your scripting language you can put the password in a file and substitute the file where the password is needed.
#!/bin/sh

# invoke say ISQL or something...
(cat $HOME/dba/password_file

cat << EOD
dbcc ...
go
EOD ) | $SYBASE/bin/isql -Usa -w1000

• Script #2

·
#!/bin/sh
·
umask 077
·
cat <<-endOfCat | isql -Umyuserid -Smyserver
·

mypassword
·

use mydb
·

go
·

sp_who
·

go

endOfCat

• Script #3

·
#!/bin/sh
·
umask 077
·
cat <<-endOfCat | isql -Umyuserid -Smyserver
·

`myScriptForGeneratingPasswords myServer`
·

use mydb
·

go
·

sp_who
·

go

endOfCat

• Script #3

·

·
#!/bin/sh
·
umask 077
·
isql -Umyuserid -Smyserver <<-endOfIsql
·

mypassword
·

use mydb
·

go
·

sp_who
·

go

endOfIsql

• Script #4

·

·
#!/bin/sh
·
umask 077
·
isql -Umyuserid -Smyserver <<-endOfIsql
·

`myScriptForGeneratingPasswords myServer`
·

use mydb
·

go
·

sp_who
·

go

endOfIsql

• Script #5

·

·
#!/bin/sh
·
echo 'mypassword
·
use mydb
·
go
·
sp_who
go' | isql -Umyuserid -Smyserver

• Script #6

·

·
#!/bin/sh
·
echo "`myScriptForGeneratingPasswords myServer`
·
use mydb
·
go
·
sp_who
·
go" | isql -Umyuserid -Smyserver

• Script #7

·
#!/bin/sh
·
echo "Password :\c "
·
stty -echo
·
read PASSWD
·
stty echo
·

·
echo "$PASSWD
·
waitfor delay '0:1:00'
·
go
" | $SYBASE/bin/isql -Usa -S${DSQUERY}

顶