The conversion of data into a form that cannot be easily understood by unauthorized users.

learn more… | top users | synonyms

7
votes
2answers
507 views

Using SQL Server with BitLocker

I have an application that is running on a device that has two partitions: C and D. The application runs off of C while D contains the SQL Server database (mdf file). In addition, D is also encrypted ...
2
votes
1answer
244 views

SSL error during SQL Server install

During my SQL Server 2014 Enterprise installation efforts, I encountered an error near the end of the install that has prevented completion. A connection was successfully established with the ...
1
vote
1answer
23 views

Check if encrpytion key is valid in DB2

I have a DB2 table where one of the columns is encrypted using the two parameter variant of ENCRYPT (so the password is supplied in the SQL itself). Unfortunately due to an ETL issue the column got ...
0
votes
1answer
21 views

Why CONTROL permission on certificate to be able to use it?

As per https://technet.microsoft.com/en-us/library/ms190499.aspx, to open a symmetric key that is encrypted by a certificate, a user needs the CONTROL permission on the certificate. I tested this and ...
0
votes
1answer
84 views

Good encryption performance

I'm converting a sql server database to postgresql 9.4. I'm stuck on something that is really really slow. I use copy to bulk insert 200 files of 5000 lines each into 200 tables (one file per table). ...
0
votes
1answer
93 views

Can we protect data form Database Administrator by encrypting the data?

How can we protect data on my database which is MySQL form database administrator stealing it? Will encrypting it prevent it from being stolen? If yes, how as he already has access to the database ...
3
votes
0answers
25 views

TDE prep: key/certificate backup for restores

I am working in a dev environment to better understand TDE encryption. I have it working along with backups and restores on another server. Had a few questions, I know I need to backup the certificate ...
2
votes
0answers
25 views

Deny BACKUP CERTIFICATE

In SQL Server, there are three database roles that have CONTROL certificate permissions. Those are db_owner, db_DDLadmin and db_securityadmin. Also, the documentation for decryptbycert specifies ...
2
votes
0answers
77 views

Restore Database w Master Key and storing password in plain text

We have a (SQL Agent)job that backs up our production db nightly(and restores to a test db server) and we're adding encryption to some of the columns in our tables. I created a master key and bound ...
2
votes
0answers
225 views

Why use asymmetric keys in SQL Server?

I've been reading multiple resources on SQL Server Encryption, and everyone does it basically the same way, but no one explains why we use asymmetric keys in SQL Server. And by this I mean when we ...
1
vote
0answers
12 views

Opening Symmetric Keys

I am trying to open a symmetric key I created in a database, but it doesn't seem to be working. I am executing the query as dbo and it even says that it is completed successfully. However, the value ...
1
vote
0answers
24 views

Can i use PGP for securing My database

I have considered TDE and cell level encryption mechanism for securing my database. but these two cannot fully satisfies my requirements.through surfing i found that PGP may help me, but it is mainly ...
1
vote
0answers
56 views

I Need to provide encryption at rest for a 50GB MySQL instance running on Centos 6.5

I can't use GusterFS because they don't recommend it and Ceph because it's clear they can't guarantee performance. I can't just encrypt certain database objects because it will take too much ...
1
vote
0answers
72 views

How to tell if Database Certificate Used?

I plan to migrate a SQL Server database to another server. There is a certificate listed under the Security > Certificates view in SSMS Object Explorer. I ran the below query to check if database is ...
1
vote
0answers
409 views

Restore of SQL service master key not required to decrypt data after migration?

This is a bit of the opposite of how this question is usually asked-- I used the following to create a database master key, a certificate, and a symmetric key: Here's how I created the certs/keys ...
1
vote
0answers
2k views

SQL Server TDE Stuck at Encryption_State 2 and 0% on a Tiny DB

I'm having a heck of a time with this issue and can't figure out what is wrong. I'm not sure how long this tiny DB has been in 'encryption_state = 2' from query: SELECT * FROM ...
0
votes
0answers
23 views

How do I generate the ENCRYPTED_VALUE for CREATE COLUMN ENCRYPTION KEY?

I can make a certificate in the windows certificate store for the master column key easily enough with: $cert = New-SelfSignedCertificate ` -Subject "Always Encrypted Sample Cert" ` ...
0
votes
0answers
18 views

Configure encryption in MariaDB specific to Windows/XAMPP

I want to configure encryption in MariaDB specific to Windows/XAMPP. Normal configuration on Linux machine is provided on MariaDB website Can anyone can suggest steps how to configure MariaDB ...
0
votes
0answers
18 views

SQL Server doesn't send intermediate SSL certificates

I am connecting to SQL Server (2008 R2) over open Internet and properly encrypting the connection is essential. I have COMODO certificate with two intermediate certificates between root CA and server ...
0
votes
0answers
29 views

Postgresql Encryption by middleware

I am trying to encrypt a Postgresql database to fit some new requirements. The applications accessing this database are already in production and I would prefer to not make changes to them. I have ...
0
votes
0answers
20 views

Move encrypted String from Oracle DB to DB2

I have a normal String athakur@test.com. It is stored encrypted in oracle DB with some encryption key. The algo used is not available in DB2 and I want the same data in DB2. I am not able to ...
0
votes
0answers
37 views

Client-side encryption in Postgres

We're developing an application that allows our clients to submit jobs to our server. After a job is submitted, the server spins up worker machines to process parts of the job. Worker machines ...
0
votes
0answers
112 views

CryptDB - cannot connect to proxy (ERROR 1105 (HY000): (proxy) all backends are down)

I install CryptDB in Ubuntu 14.04. I want to start the proxy: $ /home/user/cryptdb/bins/proxy-bin/bin/mysql-proxy \ --plugins=proxy \ --event-threads=4 \ --max-open-files=1024 \ ...
0
votes
0answers
56 views

Trigger (insert/update) and procedure Required to encrypt data in MySQL

Is there any good way of doing encryption/decryption by use of triggers and procedure in MySQL. Looking for following to achieve in sequence Unload data for specific column to some other ...
0
votes
0answers
25 views

SQL TDE Key Format

I'm trying to find the Key Format that SQL TDE uses. Is it PKCS? If so, what #? I haven't been able to identify this based on research done on MS website. And, there is no mention of key format during ...
0
votes
0answers
51 views

OPENDJ(LDAP) and Oracle 12c - Encrypted Password

I would like to know what values ​​the user authentication using a coded password accepted . In Oracle 12c of the hashing algorithm was indeed upgraded to a PBKDF2 based on SHA512 . I have an LDAP ...
0
votes
0answers
101 views

Error while creating encryption wallet in Oracle

I need to encrypt tablespaces in my Oracle DB. Following the instructions I edited sqlnet.ora file by adding ENCRYPTION_WALLET_LOCATION. Full content of file listed below: NAMES.DIRECTORY_PATH= ...
0
votes
0answers
17 views

Running Cassandra on Encypted filesystem

Looking for pointers for running Cassandra on a Linux File system encrypted by open source tools. Will this satisfy "data-at-rest" encryption ? Is the encryption transparent to Cassandra DB ...
0
votes
0answers
73 views

SQL 2012 Standard Edition (on Azure VM) + Bitlocker. Good or Bad idea?

I will start this question with a few statements to negate any "Why" questions that are going to be asked. The Head of IT wants the data encrypted. Our profession is such that encrypted data is ...