How to Find the Master Key and Table Encryption Key Used to Encrypt the Table Data

<<Back to Oracle DB Security Main Page

Finding out the Master Encryption Key and  Table  Encrypt for an Encrypted Table

SQL> SELECT ENC.OBJ#,ENC.MKEYID,ENC.COLKLC, OBJ.OBJECT_NAME,OBJ.OWNER FROM ENC$ ENC,DBA_OBJECTS OBJ
WHERE
ENC.OBJ#=OBJ.OBJECT_ID
AND OBJ.OBJECT_NAME='TABLE_NAME'