Which cryptographic practice is recommended for protecting sensitive data at rest in a relational database?
Trap 1: Using cleartext with database permissions
Cleartext provides no protection if the database file is exfiltrated.
Trap 2: Using MD5 hashing
MD5 is cryptographically broken and unsafe for passwords or data protection.
Trap 3: Storing data in base64 encoding
Base64 is an encoding, not encryption, and provides zero security.
- A
Using cleartext with database permissions
Why wrong: Cleartext provides no protection if the database file is exfiltrated.
- B
Using MD5 hashing
Why wrong: MD5 is cryptographically broken and unsafe for passwords or data protection.
- C
Using AES-256 encryption
AES-256 is the current standard for secure encryption.
- D
Storing data in base64 encoding
Why wrong: Base64 is an encoding, not encryption, and provides zero security.