Hi I have been asked to build a simple site. Problem is the want to hold patient data on that site. Each user will be able to add details about thier patient.
The database is encrypted and has always encrypted on colums. To be extra safe I would like to create a key for each user then use this to encrypt their rows with that key. So if ever there was an attach on the site each users info is encrypted different.