BE SHARING

TDE

Transparent Data Encryption – Certificate in master database: is it really a good practice?

11.12.2018 by Nathan Courtine

As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That's why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on(…)

Database Administration & Monitoring

DataGuard and Transparent Data Encryption

29.06.2018 by Oracle Team

By Mouhamadou Diaw Setting up a DatagGard environment for a database with Transparent Data Encryption requires some tasks concerning the encryption keys. Otherwise the steps are the same than for an environment without TDE. In this blog we will(…)

Database Administration & Monitoring

Oracle 18c clone PDB and Transparent Data Encryption

30.04.2018 by Oracle Team

Let’s do some tests with the Oracle 18c new feature in creating PDB clone with DBCA. Unfortunately, this feature does not work when you have TDE enabled. Just to remember, with Oracle 12.2 we had the possibility to create PDBs with(…)

Oracle

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

20.01.2018 by Oracle Team

By Franck Pachot . In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just(…)

Database Administration & Monitoring

Oracle 12.2 and Transparent Data Encryption

14.03.2017 by Oracle Team

Since the new Oracle 12.2.0 version is released, I decided to test the Transparent Data Encryption as new features are available. The following tests have been made in a multitenant environment, DB1 and two pluggable databases DB1PDB1 and DB1PDB2. The(…)

Database Administration & Monitoring

Oracle 12cR2: Online tablespace encryption

26.02.2017 by Oracle Team

By Franck Pachot . By default, all data is visible in the datafiles. Transparent Tablespace Encryption (TDE) can be used to get them encrypted. It requires Enterprise Edition plus Advanced Security Option. Except in the Oracle Cloud when it is(…)

Cloud

Oracle Public Cloud 12cR2: TDE is not an option

05.02.2017 by Oracle Team

By Franck Pachot . In Oracle Public Cloud, Transparent Data Encryption is not an option. You can use it because it is included in all database services for all editions. You have to use it because the database won't allow(…)

Database Administration & Monitoring

Encryption in Oracle Public Cloud

29.11.2016 by Oracle Team

By Franck Pachot . Oracle Transparent Data Encryption is available without option on the Oracle Public Cloud: Standard Edition as well as Enterprise Edition (EE, EE-HP EE-EP, ECS). More than that, the DBaaS enforces TDE for any user tablespace even(…)

Database management

Transparent data encryption, key management and backup strategies

26.03.2014 by Microsoft Team

Transparent Data Encryption requires the creation of a database key encryption. The database key is a part of the hierarchy of SQL Server encryption tree with at the top of the tree the DPAPI. Then if we traverse the(…)