[Openroad-users] Column Encryption

[Karl & Betty Schendel]

At 7:06 AM +1000 4/17/07, Greg Wilding wrote:
>
>Does anybody run any internal/third party Encryption tools against OpenROAD to Encrypt/De-encrypt a database column either using a code based solution or a public/private key pair


Depending on the requirements, you might be able to do OK with a
pair of user-defined functions (OME functions) to do the encrypt and
decrypt, perhaps with a rule & DB procedure to enforce encryption
going in.  (That won't help you with COPY, and you'll have to do
your own decrypting by calling your decryptor function.)

But there's no built-in solution that I know about.

Karl