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
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)
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