Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    4

    Unanswered: Sybase 12.5 dump script problem (hiding SA passwd)

    Hi,

    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.

    Thanks!
    Piggy915

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    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
    Code:
    cat /home/sybase/.pwd | isql -Usa -Sserver -i dumpscript.sql
    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •