1. Using Oracle Data Safe
  2. Data Discovery
  3. View Sensitive Data Models
  4. View Details for a Sensitive Data Model

View Details for a Sensitive Data Model

Sensitive data models are listed on the Sensitive Data Models page. You can view details for the sensitive data models to which you have access.

  1. Under Security Center, click Data Discovery.
  2. Under Related Resources, click Sensitive Data Models.
  3. Search for and click the name of a sensitive data model to view its sensitive columns and details.
  4. On the Sensitive Data Model Information tab, review the Top 5 sensitive types (by sensitive columns) chart to identify which sensitive types and sensitive categories have the most sensitive data. Click on a sensitive type within the chart to automatically filter the sensitive data model and focus on that specific type.
  5. To view the list of sensitive columns, scroll down to the Sensitive Columns section. You can organize the data three ways by selecting one of the following options from the drop-down list:
    • Flat View (default): Lists sensitive columns by either the schema, the table, or the column name in alphabetical order.
    • Sensitive Type View: Organizes the results by sensitive type.
    • Schema View: Organizes the results by schema.
  6. To explore the list of sensitive columns, do the following:
    1. Select one or more schemas from the Schema Name list. Click Load more if there are more than 1000 schemas and your desired schema is not already listed.
    2. Select one or more tables from the Table Name list. Click Load more if there are more than 1000 tables and your desired table is not already listed.
    3. Select one or more columns from the Column Name list. A list of columns will only be available once either a schema or table is selected. Click Load more if there are more than 1000 columns and your desired column is not already listed.
    4. Click Show More Options to filter by sensitive type or relationship with parent as well.
    5. Select one or more sensitive types from the Sensitive Type list. Click Load more if there are more than 1000 sensitive types and your sensitive type is not already listed.
    6. Select one of the relationships with parent from the Relation with Parent list.
    7. When all of your filters are created, click Apply.
    8. To remove a filter, click the X button next to the selected item.
  7. To view the schemas related to the sensitive data model, you can do the following:
    1. To view the schemas discovery was performed on, on the Sensitive Data Model Information tab, click the View Details link next to Selected Schemas for Discovery. The Schemas for Discovery page is displayed. Here you can view the schemas included in the discovery for the selected sensitive data model.
  8. To view the sensitive types related to the sensitive data model, you can do the following:
    1. To view the sensitive types that were discovered, on the Sensitive Data Model Information tab, click the View Details link next to Selected Sensitive Types for Discovery. The Sensitive Types for Discovery page is displayed. Here you can view the sensitive types included in the discovery for the selected sensitive data model.
  9. To view what actions have been taken on your sensitive objects, click View Activity in the Audit Records column.

    Note:

    You need to have audit policies enabled that monitor the sensitive objects to see the database activities.
    An activity auditing report with predefined filters based on the sensitive data selected is displayed.
  10. To view the work requests related to the sensitive data model, you can do the following:
    1. To view the latest work request, on the Sensitive Data Model Information tab, click the View Details link next to Work Request. The Work Request page is displayed. Here you can view the work request information, log messages, and error messages (select Error Messages under Resources).
    2. To view all the work requests for the past seven days (work requests are stored for only 7 days in Oracle Cloud Infrastructure), under Resources, click Work Requests. From here, you can view the status (for example, SUCCEEDED or FAILED), percent completed, date started, and date finished details for each work request. Click a particular work request to view its log messages and error messages.
    3. (Optional) If there was a work request failure, notice the error message displayed at the top of the page, for example, "There is at least one work request associated with this policy that has failed."