Encryption sortware for data in Oracle tables

[Frank de Vries]

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 ?

[Umapathy S]

Frank,

Did you check up this thread?

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

HTH,
Umapathy

[Yogeeraj_1]

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

[Dax Desai]

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