Data Safe

Oracle Data Safe is an OCI database security service for assessing database security posture, assessing users, auditing activity, discovering sensitive data, masking data and managing security policies. This subject area enables reporting across Data Safe target databases, audit profiles, audit trails, discovery jobs, masking policy health reports, security assessments, and user assessments, with common analysis by tenancy, compartment, region, and date.

Business Questions:

The Subject Area can answer following business questions:

  • How many Data Safe target databases are configured by tenancy, compartment, or region?
  • Which audit profiles and audit trails are available, and how are they distributed by target type or purge job status?
  • How much audit volume is collected, and how many months are online or offline for audit profiles?
  • How many sensitive data discovery jobs have run by discovery type and time period?
  • Which masking policy health reports have errors or warnings that need review?
  • How many security assessments and user assessments exist by target type, target version, tenancy, or region?
  • How have Data Safe resources and assessments changed over time?

Logical Model

The model is organized around seven Data Safe presentation fact tables. Each fact joins to shared Galaxy Resource Analytics dimensions for Compartment, Date, Region, and Tenancy, and to the corresponding Data Safe entity and fact-detail dimensions.

Data Safe Audit Profile


The Data Safe Audit Profile fact table is connected to dimension tables.

Data Safe Audit Trail


The Data Safe Audit Trail fact table is connected to dimension tables.

Data Safe Discovery Job


The Data Safe Discovery Job fact table is connected to dimension tables.

Data Safe Masking Policy Health Report


The Data Safe Masking Policy Health Report fact table is connected to dimension tables.

Data Safe Security Assessment


The Data Safe Security Assessment fact table is connected to dimension tables.

Data Safe Target Database


The Data Safe Target Database fact table is connected to dimension tables.

Data Safe User Assessment


The Data Safe User Assessment fact table is connected to dimension tables.

Metric Details

The visible presentation fact tables in this subject area expose the below metrics:

Metric Details
Fact Folder Metric Definition
Fact - Data Safe Audit ProfileAudit Collected VolumeSUM visible presentation metric from Fact - Data Safe Audit Profile.
Fact - Data Safe Audit ProfileOnline MonthsSUM visible presentation metric from Fact - Data Safe Audit Profile.
Fact - Data Safe Audit ProfileOffline MonthsSUM visible presentation metric from Fact - Data Safe Audit Profile.
Fact - Data Safe Audit ProfileData Safe Audit Profile CountCOUNT visible presentation metric from Fact - Data Safe Audit Profile.
Fact - Data Safe Audit TrailData Safe Audit Trail CountCOUNT visible presentation metric from Fact - Data Safe Audit Trail.
Fact - Data Safe Discovery JobData Safe Discovery Job CountCOUNT visible presentation metric from Fact - Data Safe Discovery Job.
Fact - Data Safe Masking Policy Health ReportError CountSUM visible presentation metric from Fact - Data Safe Masking Policy Health Report.
Fact - Data Safe Masking Policy Health ReportWarning CountSUM visible presentation metric from Fact - Data Safe Masking Policy Health Report.
Fact - Data Safe Masking Policy Health ReportData Safe Masking Policy Health Report CountCOUNT visible presentation metric from Fact - Data Safe Masking Policy Health Report.
Fact - Data Safe Security AssessmentData Safe Security Assessment CountCOUNT visible presentation metric from Fact - Data Safe Security Assessment.
Fact - Data Safe Target DatabaseData Safe Target Database CountCOUNT visible presentation metric from Fact - Data Safe Target Database.
Fact - Data Safe User AssessmentData Safe User Assessment CountCOUNT visible presentation metric from Fact - Data Safe User Assessment.