DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    I haven't heard much about it, but we are looking for ways to encrypt the stored data, without a lot of performance impact.

    Kinda like how credit card numbers are encrypted in a database, we want to do that to some columns... however these columns WOULD be used in a WHERE clause, and the unencrypted data is what is needed.

    Any ideas?


  2. #2
    Join Date
    Jul 2000
    In 8.1.6 you can use package DBMS_OBFUSCATION_TOOLKIT for encryption.

  3. #3
    what's the performance like for encrypted data? (i.e. unencrypting it when selecting it).

    If I wanted to sum up a column of numbers (and that column is encrypted), and I do:
    select sum (dbms_obfuscation_toolkit.DESDecrypt(input => COL_A, key => raw_key, decrypted_data => decrypted_raw)) from table_A;

    will that work? note, COL_A was already encrypted

    what's the performance going to be like?

    [Edited by bberg@rtnyc.com on 02-07-2001 at 04:54 PM]

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.