Unanswered: Sybase 12.5 dump script problem (hiding SA passwd)
I am a very new Sybase 12.5 DBA and I need to write a backup script which run daily on our Solaris box.
AFAIK, the dump script should first login to the sybase server by using
isql -Usa -P<sa password> .... I need some tips on how to hide the -P<sa password> from the script so that I can pass the audit requirement ?
P.S Highly appreciated if you guys can point me to those Web site which has some sample DB Maint scripts.
There are various solutions, none of them really very good.
One somewhat common solution is to have a file (eg /home/sybase/.pwd) where the sa password is stored. This file is then chmod 600 so that only "sybase" and "root" can read it. Then in your shell script you do