Results 1 to 4 of 4
  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 ?

    Thanks!
    Piggy915

  2. #2
    Join Date
    Oct 2005
    Posts
    13

    Smile

    set your password in your environment.
    (depending on your shell)

    afterwards:

    echo $YOURPASSWORD | isql -Usa -Syourservername -Dyourdatabase

    cheers

  3. #3
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    I think you should be able to also use a .file

    isql -Usa -P`cat $mydotfile` -SSERVER

  4. #4
    Join Date
    Sep 2002
    Location
    Sydney, Australia
    Posts
    255

    Do Not Use "sa" for everything ...

    1. It is bad practice to use "sa" for simple operations. Use a generic operator login and grant it "oper_role". If anyone breaks the [above] attempts at hiding the "sa" password, they will only have operations capability.

    2. Change "sa" password frequently.

    Cheers
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

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