How to Check if TDE ( Transparent Data Encryption ) is Enabled in Oracle Database

TDE ( Transparent Data Encryption ) encryption is table column level
TSE ( Tablespace Encryption ) encryption in table space level

To check if tablespace is encrypted :

SQL>SELECT tablespace_name, encrypted, status FROM dba_tablespaces;

TABLESPACE_NAME                ENC STATUS
------------------------------ --- ---------
SYSTEM                         NO  ONLINE
SYSAUX                         NO  ONLINE
UNDOTBS1                       NO  ONLINE
TEMP                           NO  ONLINE
UNDOTBS2                       NO  ONLINE
UNDOTBS3                       NO  ONLINE
UNDOTBS4                       NO  ONLINE
USERS                          YES ONLINE
...
..
.

To check if you have encrypted columns:

SQL> SELECT * FROM dba_encrypted_columns;

OWNER                TABLE_NAME           COLUMN_NAME          ENCRYPTION_ALG                SAL INTEGRITY_AL
-------------------- -------------------- -------------------- ----------------------------- --- ------------
HR                    EMPLOYEE             SALARY               AES 192 bits key              YES SHA-1


You might question the above method even there is NO encrypted tables or tablespaces, it does not mean the database has NOT been configured TDE before.

The following will confirm your database has been configured TDE or not, even there is no encrypted tables or tablespaces in database now.

Subscribe to get access

Read more of this content when you subscribe today.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.