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

learn more… | top users | synonyms

0
votes
0answers
6 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
18 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
36 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
16 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
36 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
29 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
31 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 ...
1
vote
1answer
116 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
81 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
58 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
55 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
48 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
23 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
51 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
105 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
76 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
50 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
54 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
1answer
23 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
153 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
50 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
169 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
67 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
141 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
15 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
167 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
218 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
81 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
221 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
50 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
78 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
30 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
385 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
540 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
763 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
58 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
0answers
39 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
251 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
29 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
510 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
37 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
2answers
497 views

Cannot Decrypt the encrypted columns from the database backup on local machine

I've a SQL server 2014 running on one of our server. We're in the process of implementing security steps for our databases. I've encrypted a column in one of the table in the database on the server. ...
0
votes
0answers
19 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 ...
3
votes
1answer
1k views

Alternatives to SQL Server TDE

Due to the high cost of SQL Server Enterprise Edition which includes the Transparent Data Encryption feature I am looking for an alternative product and have only found a couple of options: ...
6
votes
2answers
690 views

SharePoint 2013 Database encryption

I'm using SharePoint 2013 with SQL Server 2012 as persistence layer. I need to encrypt the data stored in the database. I stumbled upon the SQL Server feature Transparent Data Encryption (TDE). What ...
2
votes
2answers
141 views

How to safeguard a symmetric key in SQL Server

I've got a database in which I need to store the encrypted values for a column. I use the SQL Server encryption format for encryption. The format is as follows: CREATE MASTER KEY ENCRYPTION BY ...
1
vote
2answers
358 views

Encryption in SQL Server 2012/2014

We are hosting sharepoint DBs with AlwaysOn AGs and FCI. My boss asked me what the options for encryption are on the content database, it's backup files and at the column level? I have read about ...
0
votes
0answers
80 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 ...