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

learn more… | top users | synonyms

2
votes
0answers
18 views

Decrypting Previously Encrypted Data Returns NULL

I'm having trouble decrypting data that has previously been encrypted and stored in a table. After opening my symmetric key and encrypting the data using EncyptByKey(), I get NULL values when ...
1
vote
0answers
35 views

Open source & cheap 'data at rest' encryption solutions

So I am exploring some options about database encryption. The best options are commercial (TDE). I am looking for an open-source implementation. Recent releases of MySQL and MariaDB have data-at-rest ...
0
votes
2answers
61 views

Backup encryption questions

We're going to be implementing encrypted backups in SQL 2014 soon and I'd like to know the gotchas or lessons encountered by anyone else who has done the same. I've read up at MSDN and elsewhere, ...
1
vote
0answers
18 views

How can I attach the SSL authenticated certificate for my SQL Server 2014 if it is not on domain controller

We have Microsoft Azure with Windows Server 2012 R2 in Cloud Computer and window Server is Standalone it is not come under domain controller. We want to add SSL authentication. SQL Server is not ...
4
votes
1answer
167 views

TDE - Encryption on a large database

I'm in the process of researching TDE implementation on a VLDB and would like to know if anyone has real world experience with enabling encryption on a production server. What kind of problems (if ...
3
votes
1answer
88 views

Error: “The certificate cannot be dropped because one or more entities are either signed or encrypted using it.”

I have a certificate I would like to remove from the database. If I issue the command DROP CERTIFICATE <FooCert> I get the error The certificate cannot be dropped because one or more ...
1
vote
1answer
23 views

When would one want to use Oracle transparent data encryption

Oracle TDE features comes with various limitations such as not being able to encrypt columns which are used in foreign key constraints. And probably is available only with enterprise edition which ...
0
votes
0answers
17 views

SSL Issue on SQL Server 2014 DEV SP1

We have a cert on our SQL Server 2014 dev box running SP1 with force encryption enabled. If we connect to the FQDN for the box the encryption works. If you put encryption on it works and if you don't ...
0
votes
0answers
20 views

How to use an external encryption key in an Oracle function?

I am storing People data in an Oracle 11g database. I am implementing symmetric encryption on one sensitive data column in my People table. For this, I created an Encrypt function based on the example ...
0
votes
2answers
43 views

Encrypting a Database row-by-row

I have a large database (millions of rows in hundreds of tables) that contains sensitive data (Think SSNs, account numbers, etc). I am tasked with safeguarding the data and have chosen to encrypt only ...
1
vote
0answers
18 views

Accessing Encrypted SQL Server database through a web-based application

I have secured a database within SQL Server Instance on my local machine using Netlib Encryptionizer. I can access the database by securing my SQL Server instance using the same password as encrypted ...
0
votes
2answers
42 views

MySQL encryption for 'database at rest' on cloud services

We are migrating our system to a cloud environment (AWS), and have been given new client requirements for having our MySQL data-at-rest encrypted. Currently it is unclear how far this should go. It ...
0
votes
0answers
36 views

how to force mysql 5.5 server to allow tls/ssl encrypted connections only?

given a mysql Server 5.5 community edition (which came with SLES 11sp4). i configured it to support TLS and it works fine. but i did not found any options or parameters to FORCE IT to do TLS/SSL ...
0
votes
0answers
35 views

Postgresql 42883 error code with encrypt function

Ok, the thing is that I'm doing a login controller on my database. Part of it is this function to create users that goes like this: create or replace function crear_usuario(par_usuario varchar,...
1
vote
1answer
121 views

Is it possible to encrypt a column and NOT have to change app code?

Is it possible to encrypt a column (with Symmetric Key and Triple DES encryption) and then set up a login for an application such that the query code in the app does not have to be changed to used the ...
1
vote
1answer
96 views

Enable TDE When Publishing DACPAC

In the database properties in Visual Studio there is a checkbox for encryption. I'm not sure if I check this if it will enforce encryption when doing a DACPAC deploy. What I would really like to do is ...
1
vote
1answer
84 views

when to open and close symmetric keys

I am adding column encryption to a few tables using symmetric key encryption. In each one of the procs, I write code to open and close a keys. It seems a bit verbose to open and close them in each ...
1
vote
2answers
63 views

Encrypted column - limit key access

I'm new to SQL encryption and have a SQL Server 2012 database. The database itself needs to be accessible by DBAs but the data within one of the columns a table should only be viewable in plain text ...
2
votes
1answer
56 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
24 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
61 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
1answer
124 views

What is the best way to store SSH fingerprints and public keys?

I'm building a virtual Keyring in our DB to allow users to store PGP/GPG public keys with relation to email addresses so that they can optionally encrypt all communications our system sends them. I'm ...
1
vote
1answer
80 views

What encryption options are available in SQL server standard edition? [duplicate]

I'm trying to look into what kind of encryption I can do with SQL server standard edition from 2008 and later. So far, I know that I can't use Transparent Data Encryption (TDE) as that's part of ...
0
votes
3answers
56 views

Encrypt and keep sensitive data in MySQL

I have a process that parses a JSON API and loads the data into MySQL database. I have some sensitive data that should be encrypted, such as firstname, lastname, email, zip, address, credit card ...
0
votes
0answers
61 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
2answers
29 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 ...
2
votes
1answer
203 views

How to test encryption on Amazon RDS MySQL?

Our company is creating a MySQL RDS with encryption enabled. Now, as we are new to RDS, we have couple of questions related to RDS. Once we create a MySQL RDS with encryption enabled, how will we ...
0
votes
0answers
26 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 ...
1
vote
2answers
56 views

How to view security permissions for encryption keys in SQL server

Is there a way to view the security permissions assigned for encryption keys in SQL Server? Furthermore, where are all these keys stored?
2
votes
2answers
196 views

How long is the output of EncryptByPassPhrase(), relative to the input?

I'm starting an encryption project, using EncryptByPassPhrase(), mostly on VARCHAR values. Naturally, the encrypted values are longer than the originals. Is there a formula I can use to calculate ...
0
votes
0answers
74 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 ...
3
votes
1answer
158 views

MySQL secure random string generator

I am looking to generate a cryptographically secure string for password reset in MySQL. I know I could do this at the application level in PHP; but that requires the OpenSSL extension which many of my ...
1
vote
0answers
16 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 ...
0
votes
0answers
185 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 \ --...
2
votes
1answer
258 views

Encryption/Decryption with StoredProcedure/View

I'm working on a project that uses EntityFramework for programmers to access the data. We've recently found need to add fields that were determined that need to be encrypted. This will be the first ...
0
votes
0answers
90 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 ...
2
votes
2answers
291 views

How can I check if connection to Sql Server is encrypted?

In Sql Server I can Force Encrytion in protocols settings. If I leave that set to No any client can still require encryption. Can I somehow see what connections to the database are using encryption?
-1
votes
1answer
54 views

encryption key for SQL Server 2012 Reporting services [closed]

Is it required to have an encryption key for SQL Server 2012 Reporting services?
0
votes
0answers
29 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
84 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 ...
1
vote
0answers
32 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
1answer
388 views

Can we use TDE as an anti-injection technique

TDE prevent unauthorized access to the data by restoring the files to another server, because it requires the original encryption certificate and master key. If i applied a table level encryption ...
2
votes
1answer
608 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 ...
2
votes
3answers
893 views

encryption at rest for mysql

A MySQL database needs to contain highly sensitive data that cannot be left unencrypted at rest. But yet the database needs to remain searchable by an app. What are the options for encryption at ...
2
votes
1answer
63 views

Microsoft TDE Permissions For Changing Keys

I am setting up roles as a layer of protection inside of MSSQL. One of the roles will only have the ability to change database encryption keys for TDE on the database server. The server will be using ...
3
votes
1answer
45 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 ...
0
votes
0answers
315 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= (...
2
votes
0answers
30 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
2answers
553 views

Export a table and zip with password

I would like, from TSQL, to use a view to extract data from a table, output it with BCP, then use non 3rd party tools to ZIP it with a password and AES encryption. Optionnally, I could use a 3rd party ...
1
vote
1answer
45 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 ...