Data encryption

Moderator: NorbertKrupa

Post Reply
JoeM
Newbie
Newbie
Posts: 2
Joined: Tue Apr 23, 2013 10:41 am

Data encryption

Post by JoeM » Wed Apr 24, 2013 12:10 pm

Hi all

I want my data on vertica to be encrypted

Does Vertica have full data encryption solution? (or any other solution?)

Thanks
Joe

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

Re: Data encryption

Post by JimKnicely » Thu Apr 25, 2013 12:46 pm

Hi,

Why do you want the data encrypted? I'd be careful as I believe that you'd lose all of the benefits of Vertica's encoding and compression algorithms because you've altered the natural
distribution of your data! Plus you have the extra cost of decryption...

Just curious, do you want to encrypt data in your tables or on disk?

Anyway, check out this link for a possible solution to your needs:

https://github.com/vertica/Vertica-Exte ... on_package

Thanks!
Jim Knicely

Image

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

JoeM
Newbie
Newbie
Posts: 2
Joined: Tue Apr 23, 2013 10:41 am

Re: Data encryption

Post by JoeM » Thu Apr 25, 2013 2:56 pm

Why do you want the data encrypted
Because it is sensitive data, and I want to protect it in case that an unauthorized user get access to the DB (stole a user password)

I want the data in the tables encrypted

besides the link , do you have any other recommendations?

Thanks
Joe

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

Re: Data encryption

Post by JimKnicely » Thu Apr 25, 2013 3:29 pm

Hi,

Maybe the TRANSLATE fuunction can help?

viewtopic.php?f=63&t=378

Example:

Code: Select all

dbadmin=> create table emp_ssn (emp_name varchar(10), emp_ssn varchar(9));
CREATE TABLE

dbadmin=> insert into emp_ssn values ('Jim', translate('283746182', '123456789', 'XaQpKl6s*'));
 OUTPUT
--------
      1
(1 row)

dbadmin=> insert into emp_ssn values ('Jack', translate('025398491', '123456789', 'XaQpKl6s*'));
 OUTPUT
--------
      1
(1 row)

dbadmin=> select emp_name, emp_ssn, translate(emp_ssn, 'XaQpKl6s*', '123456789') from emp_ssn;
 emp_name |  emp_ssn  | translate
----------+-----------+-----------
 Jim      | asQ6plXsa | 283746182
 Jack     | 0aKQ*sp*X | 025398491
(2 rows)
You can get creative and use multiple translations combined with other string functions to "encrypt" the data... Just don't forget what you did so that you can reverse it later ;)
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”