Questions tagged [tde]

TDE, or Transparent Data Encryption, is used by Microsoft and Oracle to encrypt database content.

TDE Wikipedia page

141 questions
3
votes
0 answers

MS SQL Extensible Key Management Using AWS KMS

On Azure, there is Azure Key Vault MS SQL Server Connector to store Transparent Data Encryption keys in the key vault instead of locally. Is there a solution to store on AWS KMS? Note: I can't use AWS RDS due to some unsupported features. If…
Jeow Li Huan
  • 3,758
  • 1
  • 34
  • 52
3
votes
1 answer

Oracle - How to determine if a table is TDE encrypted

As mentioned in the topic: How to tell if in Oracle a table is encrypted with TDE or not? Couldn't find anything asking Google.
royskatt
  • 1,190
  • 2
  • 15
  • 35
2
votes
1 answer

MarkLogic TDE XPath Values from nested JSON arrays

Although MarkLogic TDE Xpath values from JSON string array has helped, I'm still having difficulty accessing values from nested JSON arrays. Here's a sample JSON document with nested arrays: { "instance": { "ID": 7, "groups": [ …
Tim Meagher
  • 163
  • 6
2
votes
1 answer

Set up Hadoop KMS

I tried to set up Hadoop KMS server and client. below is my kms.site.xml hadoop.kms.key.provider.uri jceks://file@/${user.home}/kms.keystore URI of the backing KeyProvider for the…
janith
  • 115
  • 7
2
votes
0 answers

Why encryption key is not working in Postgresql TDE during install? "Unknown data received from encryption_key_command"

I'm trying to install the Postgresql TDE from Cybertech (https://www.cybertec-postgresql.com/), specifically version 9.6.12. I followed the entire guide for default installation: $ wget…
2
votes
1 answer

Available options to restore the db from Azure MI to local machine for confidential data

I have a requirement to backup the SQL database present in Azure Managed instance and restore it on local server for root cause analysis. This needs to be performed whenever we encounter a certain error on the DB. Since the automated backups are TDE…
2
votes
1 answer

Attempting to enable Oracle Transparent Data Encryption on JDBC data source

I am trying to use Oracle TDE to connect to a JDBC data source with the following connection string:…
Chris K
  • 11,996
  • 7
  • 37
  • 65
2
votes
1 answer

TDE vs Disk Encryption advice

We are a small business that host applications and data for clients. Some of our clients are requesting we protect their data with 'encryption at rest' - although it's never very clear if they know what this really means. The data is currently on an…
userSteve
  • 1,554
  • 1
  • 22
  • 34
2
votes
1 answer

SQL Server SSL + TDE vs Always Encrypted

What is the difference between using SQL Server SSL (Encrypted=true in the connection string) + TDE, vs using SQL Server Always Encrypted? With regards to RGPD, is one more adapted than the other?
DotNetMatt
  • 648
  • 2
  • 9
  • 26
2
votes
0 answers

.Net core 2.1 and channel encryption

I had an .Net Core 2.1 application (with Visual Studio 2017 / SQL Server 2016). I am in the security phase. I search a solution to respect the GDPR norm. TDE (Transparent Data Encryption) was chosen to encrypt the database (AlwaysEncrypted was not…
2
votes
1 answer

Creating SQL Server custom EKM Cryptographic Provider DLL

This is a long shot, but here goes. I am trying to create a custom SQL Server EKM Cryptographic Provider DLL as referenced here. The problem is that nowhere can I find any reference on how to create the DLL. I came across a discussion from several…
Neil Weicher
  • 2,370
  • 6
  • 34
  • 56
2
votes
1 answer

Error restoring SQL Server 2008 R2 database with TDE enabled to SQL Server 2014

I had a database with Transparent Data Encryption (TDE) enabled in SQL Server 2008 R2. I can restore its backup successfully to another instance of SQL Server 2008 R2. However, when I restored to an instance of SQL Server 2014 SP2, the database was…
2
votes
1 answer

HIPAA compliance Encryption/Decryption for data in motion and at rest

If one is hosting an healthcare application(For me its ASP.NET MVC and going to host it in Azure cloud service) which needs to be HIPAA compliance, then encryption is required in 2 aspects: data in motion; and data at rest. Upon searching various…
2
votes
0 answers

SQL TD EKM Azure Key Vault - can't restore encrypted database

Using the steps detailed in this MS article I have successfully enabled SQL TDE using Azure as an EKM. To ensure that I would be able to decrypt the data on another server in the event of a DR scenario, I first uploaded my own asymmetric key (in the…
AndyHerb
  • 670
  • 9
  • 27
2
votes
2 answers

How to Use TDE (Transparent Data Encryption) to encrypt the column values of table SQL

I went through this link: https://msdn.microsoft.com/en-us/library/bb934049(v=sql.110).aspx Is that it, it only encrypts the database, what about the column inside the table. I used the syntax USE master; GO CREATE MASTER KEY ENCRYPTION…
A J
  • 39
  • 3
1
2
3
9 10