Posted by OFM on 10/07/06 21:14

I am running an oracle database with the application written in PHP.

I would like to be able to have the option to encrypt data residing in
certain columns in certain tables i.e. encrypt the SSNO column but not
the Fname column. I would like to keep it in its encrypted form in the
database but I would like to be able to show it to certain privileged
people based on a password.

Can public key encryption be incorporated here in the php application
such that if I can encrypt the data based on a key that in it self can
be encrypted in a way that you can revoke certain passwords if the
employee leaves - much that same way you have revocation lists
management in PGP.

Are there any suggestions on how to go about incorporating FLEXIBLE
encryption of data with PHP and Oracle?

Any help appreciated.

[Back to original message]