Oracle - 如何确定表是否经过 TDE 加密

Question

题目中提到:如何判断Oracle中的表是否使用TDE加密？无法通过 Google 找到任何内容。

Answer 1

此信息可以从[dba | all | user]_encrypted_columns获得数据字典 View

administer key management set keystore open identified by password;
administer key management set key identified by password with backup;

-- test table with one encrypted column   
create table tb_encrpt (
  c1 varchar2(10) encrypt
)
tablespace encrypt_tbs;

显示有关加密表列的信息

column table_name format a10;
column column_name format a10;
column encryption_alg format a10;

select table_name
     , column_name
     , encryption_alg
  from dba_encrypted_columns

结果:

TABLE_NAME COLUMN_NAM ENCRYPTION
---------- ---------- ----------
TB_ENCRPT  C1         AES 192 bi


1 row selected.

How to tell if in Oracle a table is encrypted with TDE or not?

如果表不在[dba |所有 | user]_encrypted_columns 则它没有加密列。