Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    165

    Unanswered: Encryption of column

    I want to encrypt one column in one table (column contain very sensitive integer,for example,salary) with password or sth similar.
    I will explain setup on DB2 (how it works with DB2 database):
    Table is defined as
    CREATE TABLE NONAME
    NAME CHAR(100)
    SALARY INTEGER FOR BIT DATA
    This option "for bit data" means that value will be encrypted.
    When you want to insert new,encrypted value,just enter
    1) SET ENCRYPTION PASSWORD='ORACLE'
    insert into noname values ('zkajfez',1000)

    or

    2) insert into noname values('zkajfez',encrypt(1000))

    if you try to enter just
    select * from noname result have to be like this:
    zkajfez x'089B65FFE204ABD58888A1B34B8D531C2020202020202020 202020202020202020202020202020x'089B65FFE204ABD588 88A1B34B8D531C202020202020202020202020202020202020 2020202020x'089B65FFE204ABD58888A1B34B8D531C202020 2020202020202020202020202020202020202020

    to read real sallary you have to enter
    select name, decrypt(salary,'ORACLE') from noname
    where 'ORACLE' is password which encypted values
    So,how to setup this in Oracle?
    Without having to worry about keys etc
    TIA

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Oracle has the same type of encryption packages using triple-DES. See the following link.

    http://download-east.oracle.com/docs...l.htm#ARPLS028
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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