Encrypted Column
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Encrypted Column

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    I want to encrypt the 'password' and store it in the database and decrypt it on a 'later' date.

    I am using the dbms_obfuscation_toolkit package as suggested by oracle.
    Problem is, when I use the dbms_obfuccation package, the data will be converted to raw and then encrypted and stored again in the raw variable. For the display purpose we convert the raw variable using - rawtohex .

    Now, I want to just encrypt the data and store in the table.

    1) what should be the column type for storing this encryted password .

    2)Can I store the encrypted data in the varchar2 datatype column and if so how do I decrypt this data later.


    Badrinath

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    Anybody who has stored the encrypted field ,please help me
    Badrinath

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Did you use the procedure

    Hi, 11th May 2001 21:14 hrs *******

    This link throws you more on the encryption of data as well as index datas plus the Oracle partners products such as Protegrity giving solutions for your problem.

    http://otn.oracle.com/deploy/securit...df/f5crypt.pdf

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon 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
  •  


Click Here to Expand Forum to Full Width