Questions tagged [tde]

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

TDE Wikipedia page

141 questions
0
votes
2 answers

What is the reason for using "user_Id:password" for PKCS11 when it only accepts a pin?

With respect to Oracle Database 11g transparent data encryption (TDE) with HSM, I understand that the following command is used to set the master encryption key. However, why does a user_Id have to be specified when the PKCS#11 library for the…
Lopper
  • 3,499
  • 7
  • 38
  • 57
0
votes
2 answers

Transparent Data Encryption (TDE) for Azure SQL Database

Can we use TDE feature with Azure SQL Database in production application? Or only SQL Sever Enterprise edition declares TDE feature as released?
vovakh
  • 93
  • 1
  • 1
  • 4
0
votes
1 answer

SQL Server 2008 - Transparent Data Encryption undecrypted access

My question is a duplicate of - Oracle Transparent Data Encryption undecrypted access - but for SQL Server 2008. Can I set up a SQL Server 2008 database in a way that all of the following statements are true? a) certain columns, potentially all…
Peanut
  • 18,967
  • 20
  • 72
  • 78
0
votes
1 answer

SQL Server : encrypted column content not visible

I am trying to encrypt some sensitive information on a database (SQL Server 2008 R2 Enterprise Edition) using the TDE encryption. This is the test code I am doing : use test1 create table users1(pid int not null, username varchar(20), pass…
0
votes
0 answers

Error when restoring encrypted database

I use the following to create certificate for database encryption. use master --create certificate CREATE CERTIFICATE Cert4TDE WITH SUBJECT = 'Certificate for TDE'; GO --back up certificate BACKUP CERTIFICATE Cert4TDE TO FILE =…
hoanvd1210
  • 149
  • 5
  • 15
0
votes
1 answer

SQL Server 2008 R2 tde stop encryption process

I have a rather larger database I will be encrypting using TDE. I have a defined window to complete the encryption. I need a way to stop the encryption process if the time window is exceeded. Thanks
Jason Bestor
  • 99
  • 1
  • 2
  • 10
0
votes
1 answer

Role or User based access to TDE encryption in Oracle

Env: Oracle 11g DB with a Java based application We are looking to encrypt data in our database, for a few sensitive columns of a table. We would like these columns to be decrypted and visible to a set of users A. And we DO NOT want these…
Chitkala
  • 1
  • 2
0
votes
1 answer

How can i access TDE enabled column in Java application?

We are using Oracle TDE to protect sensitive data. We have only enabled TDE on one column. And we want the java application developer to access that sensitive column data in java code. But to access the plain text data we need to open the wallet…
DineshM
  • 829
  • 1
  • 15
  • 24
0
votes
1 answer

Using sql server 2008 and TDE is it possible to create a database backup that is not encrypted?

Is it possible to take a database that is using TDE and create a backup file that is not encrypted? I know that I could create a backup, import into another database (using the key and certificate), turn off TDE and create a backup. I'm wondering if…
yamspog
  • 18,173
  • 17
  • 63
  • 95
0
votes
1 answer

SQL Server: Delete and Backup TDE Databases

maybe the question is to trivial and that's why I can't find something online: I need to make sure that a TDE encrypted database can be easily backed up and deleted without touching any certificates or keys. Am I right? Deleting and backing up is…
0
votes
1 answer

Mysql Database TDE Encryption through xampp?

I have been trying to figure out how to transparent data encryption my Mysql Database for weeks. Time is running out. I need help.. I am using xampp and possibly going to turn to Postgres. If TDE is not possible for xampp mysql, then is there a way…
OneNation
  • 427
  • 1
  • 8
  • 22
0
votes
1 answer

Using TDE on MySQL in Windows Server 2008 R2

I was looking around for some solution to bring TDE to MySQL. I found this question asked in here before. But the question seems to be about enabling a TDE solution to a MySQL database that is installed in a Linux environment. In my case, I would…
Shabutie
  • 5
  • 4
0
votes
5 answers

In SQL Server 2008 how can I secure data in a way that it cannot be decrypted unless connected to a network?

We have recently implemented Transparent Data Encryption in SQL Server 2008 for local databases on our developers laptops to keep them protected in the case a laptop is stolen or lost. This works fine. Now we are trying to figure out a way to have…
rmontgomery429
  • 14,660
  • 17
  • 61
  • 66
0
votes
1 answer

Does altering SQL Server 2008 R2 Database Master Key seamlessly change dependent keys?

In SQL Server 2008 R2, If I alter the database master key do I have to make any changes to certificates that change user data base encryption keys. I have an annual update requirement. So if I do this: USE [Master]; ALTER MASTER KEY REGENERATE WITH…
Jeff Maier
  • 131
  • 1
  • 2
  • 6
0
votes
1 answer

TDE Enabled database connection string in ADO.Net using C#

I have a .mdf file and i can attach it at run time and access it from C#.But if the same file is TDE enabled i am not getting the format of connection string to be used for attaching it.Please help
Siddharood
  • 908
  • 1
  • 12
  • 24
1 2 3
9
10