Encrypt Column Data
Posted: Tue Apr 04, 2017 1:38 pm
Is it possible to encrypt a columns data so that it is not viewable? Like for an SSN? Or does thar even make sense in a database like Vertica?
There is an encryption function available out on Github... It consists of a pair of AES encryption/decryption functions. This enables field-level encryption within Vertica using the industry standard AES algorithm.
See: https://github.com/vertica/Vertica-Exte ... on_package
For performance reasons, a better option is to look into column access policies:
See: https://my.vertica.com/docs/8.0.x/HTML/ ... POLICY.htm