Oracle Database Sensitive Data Assessment Report
The Discoverer component is used to generate the Oracle Database Sensitive Data Assessment Report in HTML, CSV, and JSON formats.
The HTML report is the main report and contains the discovered sensitive data and its categories along with target database information and Discoverer parameters.
The CSV report can be loaded into Oracle Audit Vault and Database Firewall to add sensitive data context to the new Data Privacy reports. For more information about this functionality, see Importing Sensitive Data Into AVDF Repository in the Oracle Audit Vault and Database Firewall Auditor's Guide. The JSON format can be used for integration with other tools.
Oracle Database Sensitive Data Assessment Report - High-Level Summary
The Oracle Database Sensitive Data Assessment Report - High-Level Summary section contains the following information:
| Section | Description |
|---|---|
| Assessment Time & Date | Displays when the Sensitive Data Assessment report was generated. The DBSAT Discoverer version is also displayed. |
| Database Identity | Displays the details of the database assessed by the Discoverer. |
| Database Version | Displays the version of the database assessed by the Discoverer. |
| Discovery Parameters | Displays the Discovery Parameters specified in the configuration file. For more information about Discovery Parameters, see Configuration Settings. |
The following figure displays the first four tables of the Oracle Database Sensitive Data Assessment Report - High-Level Summary section.
Oracle Database Sensitive Data Assessment Report - Summary
The Oracle Database Sensitive Data Assessment Report - Summary section displays information about the number of tables, columns, and rows identified as sensitive data, grouped by Sensitive Category.
The Database Sensitive Data Assessment Report - Summary section contains the following columns:
| Column Name | Description |
|---|---|
| Sensitive Category | Displays the name of the Sensitive Category |
| # Sensitive Tables | Displays the number of tables detected that contain sensitive data |
| # Sensitive Table Columns | Displays the number of columns detected in the tables that contain sensitive data |
| # Sensitive Table Rows | Displays the number of table rows containing data classified under a specific sensitive category |
| # Sensitive Views | Displays the number of views detected that contain sensitive data |
| # Sensitive View Columns | Displays the number of columns detected in views that contain sensitive data |
The following figure displays the information displayed in the Oracle Database Sensitive Data Assessment Report - Summary section:
Description of the illustration Oracle Database Sensitive Data Assessment Report - Summary
Note:
A single database table could contain columns or column comments that match more than one Sensitive Category, causing a higher number to be displayed in the # Sensitive Tables and # Sensitive Rows columns. However, the Total row displays the unique number of tables and rows identified as sensitive data.
For more information about configuring Sensitive Categories, see Pattern File Configuration.
Oracle Database Sensitive Data Assessment Report - Sensitive Data
The Oracle Database Sensitive Data Assessment Report - Sensitive Data section displays information about the schemas containing sensitive data. It contains the following information:
| Section | Description |
|---|---|
| Risk Level(s) | Displays the Risk Level(s) of the sensitive data identified in the schema of the database assessed by the Discoverer. |
| Summary | Displays a summary of the occurrence of sensitive data in the schema. |
| Location | Displays the names of the schemas containing sensitive data. |
The following figure shows the information displayed in the Oracle Database Sensitive Data Assessment Report - Sensitive Data section.
Description of the illustration Oracle Database Sensitive Data Assessment Report - Sensitive Data
The following figure shows the information displayed in the Risk Level: High Risk section:
Description of the illustration Sensitive categories grouped by Risk Level
Each Risk Level section is followed by a list of the tables detected that contain sensitive data. The following information is displayed:
Table: Objects Detected within Sensitive Category:
| Name | Description |
|---|---|
| Risk Level | Displays the Risk Level |
| Summary | Displays a summary of the sensitive category data detected |
| Location | Displays the names of the tables and views that contain sensitive data |
The following figure shows the information displayed in the Objects Detected within each Sensitive Category: subsection:
Description of the illustration Objects Detected within Sensitive Category
Oracle Database Sensitive Data Assessment Report - Schema View
The Oracle Database Sensitive Data Assessment Report - Schema View section displays information about the schemas, tables, columns, and rows containing sensitive data. The Sensitive Category is also displayed. This report contains the following columns:
| Column Name | Description |
|---|---|
| Schema Name | Displays the name of the schema |
| Object Name | Displays the object name |
| Object Type | Displays the object type - Table/View |
| Columns | Displays the number of columns in the table |
| Sensitive Columns | Displays the number of columns detected that contain sensitive data |
| Rows | Displays the number of rows in the table |
| Sensitive Category | Displays the category of sensitive data detected in each column |
The following figure highlights the information displayed in the Oracle Database Sensitive Data Assessment Report - Schema View section:
Description of the illustration Oracle Database Sensitive Data Assessment Report - Schema View
Oracle Database Sensitive Data Assessment Report - Sensitive Column Details
The Oracle Database Sensitive Data Assessment Report - Sensitive Column Details section displays information about the columns containing sensitive data.
The Sensitive Category and Type are also displayed.
| Column Name | Description |
|---|---|
| Schema Name | Displays the name of the schema |
| Object Name | Displays the object name |
| Object Type | Displays the object type - Table/View |
| Column Name | Displays the name of the column |
| Column Comment | Displays the column comment |
| Sensitive Category | Displays the category of sensitive data detected in each column |
| Sensitive Type | Displays the type of sensitive data detected in each column |
| Risk Level | Displays the risk level |
The following figure displays the information displayed in the Oracle Database Sensitive Data Assessment Report - Sensitive Column Details section:
