Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Encryption sortware for data in Oracle tables

Frank de Vries
Respected Contributor

Encryption sortware for data in Oracle tables

Our company doctor has a question if it there is some software we can use to encrypt the contents of data the medical data-model in Oracle tables.
The retrieval of the data should use some kind of key/code that only the doctors should know.

They attach to the tables using Ms/Access through odbc link, but this is not necessary.

(Oh before I forget , even the dba shouldn't be able to read the tables, so it is that kind
of encryption)
Any ideas / experiences with this ?
Look before you leap
3 REPLIES
Umapathy S
Honored Contributor

Re: Encryption sortware for data in Oracle tables

Frank,

Did you check up this thread?

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x26612d88ce9cd711abdc0090277a778c,00.html

HTH,
Umapathy

Arise Awake and Stop NOT till the goal is Reached!
Yogeeraj_1
Honored Contributor

Re: Encryption sortware for data in Oracle tables

hi,

There are several ways, you can do this.

One of the ways is one which i explained this morning in the thread below:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x26612d88ce9cd711abdc0090277a778c,00.html

I will try to find other ways and update this post.

hope this helps!

Best Regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Dax Desai
Occasional Visitor

Re: Encryption sortware for data in Oracle tables

DBMS_OBFUSCATION package will provide tools necessary to encrypt tables. This is "the" package in oracle for this purpose. It should give you everything you require for encrypting tables in your database.


Dax Desai
SBC Communications
dax@sbc.com