Answers

Question and Answer:

  Home  Sybase

⟩ Hiding your password to isql in Sybase?

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

*

 124 views

More Questions for you: