Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Table or column encryption
Hi all,
Forgive me...tired today and just need to think out loud. New company is going to take over and redevelop the app I have done for a client and move it into MSFT Dynamics (or at least that is the plan - we'll see if they can get it to do what the VFP app did).
We have talked about data encryption. This company has a lot of sensitive data (PII, banking, payments data etc.) which we handled in VFP by doing field level (column level) encryption. So now I am talking to them about what they are proposing for encryption.
Not knowing SQL (which is what I assume is behind Dynamics), I am flying a bit blind here in my discussions.
They are suggesting "file level encryption" at the database level. They are not really clear - I think they are suggesting encrypting the entire database in SQL. We did the column level encryption because even if this company had a data breach and scooped up all the VFP tables, they would still not be able to read the columns with sensitive information.
How have others encrypted data - pros and cons and what scenarios were you trying to protect against?
Thanks,
Albert
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement