Does anybody has used Data encryption on Oracle (Encryption Wizard for Oracle)?
Does it works well with Baan tables? Does Baan work OK with tables encrypted?

If yes, what type of encryption? AES128? AES256? DES?

Thanks for your help!


William

You can use the toolkit dbms_obfucation that comes with Oracle. It works like a charm.

You can use insert trigger to encrypt data and select trigger to decrypt data.

You can make use of synonyms, views and a new schema to restrict decryption to only certain users.

Hello Nancy,

Can you please tell more how it works , if you have implemented this can you share your thoughts and experience .

Thanks