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
1 answer

TDE feature in Postgresql Community edition

May I know if transparent data encryption is now available natively in PostgreSQL
Tom
  • 21
  • 5
0
votes
1 answer

Storing encryption key outside Oracle database

My requirement is to do column level encryption. Tried below option TDE - data is not encrypted to one who has access to database. Please correct me if I'm wrong. DBMS_CRYPTO package, this works but client wants to store encryption key outside…
0
votes
0 answers

Is it possible to assign graphs/collection to TDE generated triples?

I know that TDE generates unmanaged triples, and unmanaged triples are not part of graphs by default. So is there any way to put these TDE generated triples in specific graphs or collections?
anuj_gupta
  • 131
  • 4
0
votes
1 answer

Can we put triples in specific graph or collections for Triples generated via TDE?

I know that TDE generates unmanaged triples, and unmanaged triples are not part of graphs by default. So is there any way to put these TDE generated triples in specific graphs or collections?
AkG
  • 31
  • 3
0
votes
1 answer

SQL Server TDE and cross subscription restore

I need to be able restore Azure SQL Server databases from one subscription to another (example: Prod to Dev environments that exist in different subscriptions). The databases will have TDE enabled. What is the implication with respect to TDE for the…
SuttyHoo
  • 130
  • 8
0
votes
1 answer

sys.dm_database_encryption_keys not showing all encrypted databases, unless selecting the database with USE db_name

All six databases have been encrypted, but the status (in sys.dm_database_encryption_keys) is only showing correctly for three out of the six databases. To be able to see the correct status, I first need to select the database with the USE db_name…
0
votes
0 answers

How to read Oracle Datafile .dbf using stings command in Unix

I am in the process of implementing TDE in Oracle Database. I am trying to read the datafile using STRINGS command in UNIX but instead of displaying values the command is showing as below $ strings tbs1pdbtde.dbf }|{z DBDEMO TBS1PDBTDE Instead of…
0
votes
1 answer

How to find out which documents having compliance issue with TDE in Marklogic

I guess behind TDE, ML will still create different types of indexes. TDE greatly simplify the task to maintain the indexes. However, the traditional ML Indexes are not mandatorily reinforced on all the documents in DB. For example, if some documents…
0
votes
1 answer

MariaDB 10.6.3 fails to start after enabling File Key Management Encryption

I'm trying to enable File Key Management encryption in MariaDB 10.6.3 server (Rocky Linux). I'm generating key file using open ssl. I have followed this guide…
Sims Susee
  • 11
  • 4
0
votes
2 answers

Postgres TDE capability only for specific schema

As part of GDPR requirement we need to encrypt data at rest. We are planning to use Postgres and from the below links looks like TDE can be achieved in Postgres as…
lives
  • 1,243
  • 5
  • 25
  • 61
0
votes
1 answer

SQL Server TDE - use T-SQL to show if there is a database key

I can tell if a SQL Server TDE Master Key exists with this T-SQL query: if not exists (SELECT name FROM sys.symmetric_keys WHERE symmetric_key_id = 101) begin -- Master Key does not exist. Create one here. end; Is there a query to determine…
Neil Weicher
  • 2,370
  • 6
  • 34
  • 56
0
votes
0 answers

Can primary keys (and FKs) be encrypted in Oracle 11g?

Given a requirement from a customer, they want to anonymize their DB for their development team, but they are asking if primary keys can be encrypted. By looking a bit into the oracle TDE documentation seems this is not possible... Is there an…
Juan Zamora
  • 386
  • 4
  • 11
0
votes
0 answers

Apply TDE on database SQL Server success, but later show not encrypted

I would like to ask about encryption M.S SQL Server 2016. I have applied encryption on database production long time, but a few months later It show status not encrypted. What happen to it? Note Table sys.dm_database_encryption_keys" no database in…
Srean
  • 9
  • 1
0
votes
1 answer

Oracle TDE -- Salt and Encrypted Data

For Oracle TDE, there is both the option to add salt to plaintext (by default) or to ignore salt (using the NO SALT) parameter. I wanted to know if salt is unique per row/record in a table or common across all rows in a single table. Is there any…
Prasanth Ravi
  • 145
  • 1
  • 11
0
votes
1 answer

SQL Server 2016 TDE Encryption on big text column

We implemented SQL TDE (SQL 2016) successfully on columns smaller in text size, but will give error on large columns Table Structure ID - value 1 - wanted to confirm her order for the install, adv that the activation date was set 2 - Edward called…