data encryption

[gvgp]

Hi,


Is there any way to encrypt the data before storing it into database and decrypt the data before presenting it to the user. We are using Oracle 8i database.



Rgds,
gv.

[pwoneill]

have you tried the dbms obfusacation toolkit? it's a supplied package with oracle 8i.

[gvgp]

I have no idea about that package. Where can I find any information about it. Are there any 3rd party tools available?


Rgds,
gv

[sreddy]

Its given in one of the latest(last 2 editions) Oracle Magazine.

[steviep9]

Note.102902.1 Ext/Pub Encrypting Data using the DBMS_OBFUSCATION_TOOLKIT package:

[maachan]

Has anyone written triggers to encrypt and decrypt data using this toolkit?
I have not had much success, and would like to know how to go about it.
Specifically, if user A owns the tables where the encrypted data is stored, but userB inserts, updates and selects the encrypted data from the table, who's schema should the trigger be created under and what permissions for the toolkit does that schema owner need?

Thanks

[wwalice]

hello,

I use this oracle package to encrypt a clolumn and insert the encrypted data into database.

The length for the column must at least 2048? If i give varchar2(1024) is there some trouble?

Thanks in advance.