DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: data encryption

  1. #1
    Join Date
    Oct 2000
    Posts
    17
    Hi,


    Is there any way to encrypt the data before storing it into database and decrypt the data before presenting it to the user. We are using Oracle 8i database.



    Rgds,
    gv.

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    have you tried the dbms obfusacation toolkit? it's a supplied package with oracle 8i.

  3. #3
    Join Date
    Oct 2000
    Posts
    17
    I have no idea about that package. Where can I find any information about it. Are there any 3rd party tools available?


    Rgds,
    gv

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Its given in one of the latest(last 2 editions) Oracle Magazine.

  5. #5
    Join Date
    Aug 2000
    Location
    Toronto, Ontario Canada
    Posts
    52
    Note.102902.1 Ext/Pub Encrypting Data using the DBMS_OBFUSCATION_TOOLKIT package:

  6. #6
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    Has anyone written triggers to encrypt and decrypt data using this toolkit?
    I have not had much success, and would like to know how to go about it.
    Specifically, if user A owns the tables where the encrypted data is stored, but userB inserts, updates and selects the encrypted data from the table, who's schema should the trigger be created under and what permissions for the toolkit does that schema owner need?

    Thanks

  7. #7
    Join Date
    Jul 2000
    Posts
    68
    hello,

    I use this oracle package to encrypt a clolumn and insert the encrypted data into database.

    The length for the column must at least 2048? If i give varchar2(1024) is there some trouble?

    Thanks in advance.

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