Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Nottingham - UK

    Unanswered: SQL 7 DATA Encryption


    Could anyone please advise on SQL data encrpytion ?

    We have a HR database that has to be encrpyted from everyone including DBA's

    DOes anyone know of any products that will cater for this ?


  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    You can encrypt the database completely using the -e switch during dbinit.
    dbinit - e -p 1024 test.db

    Encrypt the database (-e)

    Encryption makes it more difficult for someone to decipher the data in your database by using a disk utility to look at the file. File compaction utilities cannot compress encrypted database files as much as unencrypted ones.

    The encryption used is intended only to keep data hidden in the event of casual direct access of the database file.

    You can also encrypt packets that that hit the network, by using the same -e switch at db engine startup

    dbsrv7 -e test.db

    If you are after strong encryption, I know SQL Anywhere group has technology partnerships with other vendors. Not quite sure about the names.

    Until later


Posting Permissions

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