Encrypt Column Data

Moderator: NorbertKrupa

Post Reply
sangxuan513
Newbie
Newbie
Posts: 1
Joined: Tue Apr 04, 2017 1:34 pm

Encrypt Column Data

Post by sangxuan513 » 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?
:D :D :D

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Encrypt Column Data

Post by JimKnicely » Wed Apr 05, 2017 11:39 pm

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
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica”