How to find which policies are assigned to an EDM

Products

• Data Loss Prevention
• Data Loss Prevention Enforce

Issue/Introduction

When trying to delete an Exact Data Profile (EDM) in the Data Loss Prevention (DLP) Enforce Console, the following error appears.

"This registered content has policies that depend on it. Please remove those policies first."



How can we identify which policy is assigned to the EDM?

Environment

Data Loss Prevention 15.7, 15.8, and 16.0 
Oracle 19c

Cause

The error appears as DLP see's there's a policy assigned to the EDM.

Resolution

Run the attached EDMPolicyAssignment.sql against the database to see:

• The EDM name
• Which policy is assigned to the EDM
• The rule/condition in the policy where the assignment can be found

Then use the query results to delete the EDM rule from the policy.

Do not modify the query.
It is a select statement only.
If you have issues running the query, open a case with Support and reference this KB.