Encrypt Column Data
Moderator: NorbertKrupa
-
- Newbie
- Posts: 1
- Joined: Tue Apr 04, 2017 1:34 pm
Encrypt Column Data
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?
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Encrypt Column Data
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
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
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.