Which tables and columns in the Symantec DLP Database are Encrypted?


Article ID: 159530


Updated On:


Data Loss Prevention Enforce


What tables and columns in the Oracle database are encrypted by DLP?




For Symantec DLP version: 10.x and later

Look for the following table.columns to be encrypted:

Table: MessageLob

Column: networkOriginalMessage

Table: MessageComponentLob

Columns: uncrackedcomponent and crackedcomponent

The columns described are BLOBs. All tables listed belong to user protect.

In terms of incident components, the encrypted parts of an incident are: list of matches, original message (if present) and file attachment (if present). 

Encryption is performed by the DLP application, which is to say, outside of the Oracle database.  Oracle encryption functionality is not used.