where can I find about the pl/sql encryption toolkit
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: where can I find about the pl/sql encryption toolkit

  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?


    thanks.


  2. #2
    Join Date
    Jul 2000
    Posts
    296
    In 8.1.6 you can use package DBMS_OBFUSCATION_TOOLKIT for encryption.
    [url]http://otn.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_obf.htm[/url]

  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