Page 1 of 1
Encrypt Column Data
Posted: Tue Apr 04, 2017 1:38 pm
by sangxuan513
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?
Re: Encrypt Column Data
Posted: Wed Apr 05, 2017 11:39 pm
by JimKnicely
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