Hi all
I want my data on vertica to be encrypted
Does Vertica have full data encryption solution? (or any other solution?)
Thanks
Joe
Data encryption
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Data encryption
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!
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
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.
Re: Data encryption
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)Why do you want the data encrypted
I want the data in the tables encrypted
besides the link , do you have any other recommendations?
Thanks
Joe
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Data encryption
Hi,
Maybe the TRANSLATE fuunction can help?
viewtopic.php?f=63&t=378
Example:
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
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)
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.