topic Encryption sortware for data in Oracle tables in Operating System - HP-UX

Encryption sortware for data in Oracle tables

Frank de Vries — Tue, 17 Jun 2003 13:17:59 GMT

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 ?

Re: Encryption sortware for data in Oracle tables

Umapathy S — Tue, 17 Jun 2003 13:21:31 GMT

Frank,

Did you check up this thread?

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

HTH,
Umapathy

Re: Encryption sortware for data in Oracle tables

Yogeeraj_1 — Tue, 17 Jun 2003 17:01:45 GMT

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

Re: Encryption sortware for data in Oracle tables

Dax Desai — Wed, 18 Jun 2003 13:18:10 GMT

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