How to secure DB entries for users having personal data?
Pranam Bhat
Cosnider you are storing users personal information (Such as Email ID, Aadhar Number, DOB, Mobile Number, etc.). In this scenario, how you will secure this data?
One crucial thing is never storing passwords in DB unencrypted. Furthermore secure hashing algorithm such as Argon2 should be used.
For databases hosted in Cloud, the Cloud Service Provider gives the option to enable TDE (Transparent Data Encryption).
For databases hosted in on-premise, refer this articlehttps://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-ver15