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

book

Article ID: 159530

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

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

Resolution

 

 

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.