Nested table type of varchar2(32767).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_varchar2_tbl FORCE IS TABLE OF (varchar2(32767)) NOT PERSISTABLE;

The database credentials required for Data Safe to connect to the database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_credentials_t FORCE AUTHID CURRENT_USER IS OBJECT (
  user_name varchar2(32767),
  password varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_credentials_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_credentials_t (
    user_name varchar2,
    password varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to reactivate a previously deactived target database in Data Safe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_activate_target_database_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  credentials dbms_cloud_oci_datasafe_credentials_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_activate_target_database_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_activate_target_database_details_t (
    credentials dbms_cloud_oci_datasafe_credentials_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of a Data Safe Alert, that shows alerts generated by a Data Safe feature.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  status varchar2(32767),
  severity varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  operation_time timestamp with time zone,
  operation varchar2(32767),
  operation_status varchar2(32767),
  target_ids dbms_cloud_oci_datasafe_varchar2_tbl,
  target_names dbms_cloud_oci_datasafe_varchar2_tbl,
  policy_id varchar2(32767),
  alert_type varchar2(32767),
  resource_name varchar2(32767),
  feature_details json_element_t,
  l_comment varchar2(32767),
  compartment_id varchar2(32767),
  lifecycle_state varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_t (
    id varchar2,
    status varchar2,
    severity varchar2,
    display_name varchar2,
    description varchar2,
    operation_time timestamp with time zone,
    operation varchar2,
    operation_status varchar2,
    target_ids dbms_cloud_oci_datasafe_varchar2_tbl,
    target_names dbms_cloud_oci_datasafe_varchar2_tbl,
    policy_id varchar2,
    alert_type varchar2,
    resource_name varchar2,
    feature_details json_element_t,
    l_comment varchar2,
    compartment_id varchar2,
    lifecycle_state varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of aggregation dimension summarizing alerts.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alerts_aggregation_dimension_t FORCE AUTHID CURRENT_USER IS OBJECT (
  group_by json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alerts_aggregation_dimension_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alerts_aggregation_dimension_t (
    group_by json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of alerts aggregation items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_aggregation_items_t FORCE AUTHID CURRENT_USER IS OBJECT (
  metric_name varchar2(32767),
  time_started timestamp with time zone,
  time_ended timestamp with time zone,
  l_count number,
  dimensions dbms_cloud_oci_datasafe_alerts_aggregation_dimension_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_aggregation_items_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_aggregation_items_t (
    metric_name varchar2,
    time_started timestamp with time zone,
    time_ended timestamp with time zone,
    l_count number,
    dimensions dbms_cloud_oci_datasafe_alerts_aggregation_dimension_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_alert_aggregation_items_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_aggregation_items_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_alert_aggregation_items_t) NOT PERSISTABLE;

The summarized detail of alerts aggregation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_analytics_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_alert_aggregation_items_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_analytics_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_analytics_collection_t (
    items dbms_cloud_oci_datasafe_alert_aggregation_items_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a Data Safe Alert.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  status varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  severity varchar2(32767),
  operation_time timestamp with time zone,
  operation varchar2(32767),
  operation_status varchar2(32767),
  target_ids dbms_cloud_oci_datasafe_varchar2_tbl,
  target_names dbms_cloud_oci_datasafe_varchar2_tbl,
  policy_id varchar2(32767),
  alert_type varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  feature_details json_element_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_summary_t (
    id varchar2,
    status varchar2,
    display_name varchar2,
    description varchar2,
    severity varchar2,
    operation_time timestamp with time zone,
    operation varchar2,
    operation_status varchar2,
    target_ids dbms_cloud_oci_datasafe_varchar2_tbl,
    target_names dbms_cloud_oci_datasafe_varchar2_tbl,
    policy_id varchar2,
    alert_type varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    feature_details json_element_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_alert_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_alert_summary_t) NOT PERSISTABLE;

Collection of alert summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_alert_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_collection_t (
    items dbms_cloud_oci_datasafe_alert_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An Alert Policy is a set of alerting rules evaluated against a target. The alert policy is said to be satisfied when all rules in the policy evaulate to true. If there are three rules: rule1,rule2 and rule3, the policy is satisfied if rule1 AND rule2 AND rule3 is True.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_policy_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  alert_policy_type varchar2(32767),
  is_user_defined number,
  severity varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    alert_policy_type varchar2,
    is_user_defined number,
    severity varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a Data Safe alert policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_policy_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  alert_policy_type varchar2(32767),
  is_user_defined number,
  severity varchar2(32767),
  compartment_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_summary_t (
    id varchar2,
    display_name varchar2,
    description varchar2,
    alert_policy_type varchar2,
    is_user_defined number,
    severity varchar2,
    compartment_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_alert_policy_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_policy_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_alert_policy_summary_t) NOT PERSISTABLE;

Collection of alert policy summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_policy_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_alert_policy_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_collection_t (
    items dbms_cloud_oci_datasafe_alert_policy_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A rule associated with a alert policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_policy_rule_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  description varchar2(32767),
  expression varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_rule_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_rule_t (
    key varchar2,
    description varchar2,
    expression varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A rule associated with an alert policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_policy_rule_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  description varchar2(32767),
  expression varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_rule_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_rule_summary_t (
    key varchar2,
    description varchar2,
    expression varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_alert_policy_rule_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_policy_rule_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_alert_policy_rule_summary_t) NOT PERSISTABLE;

Collection of alert policy rules summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alert_policy_rule_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_alert_policy_rule_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_rule_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alert_policy_rule_collection_t (
    items dbms_cloud_oci_datasafe_alert_policy_rule_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details to update alerts in the specified compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_alerts_update_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  status varchar2(32767),
  compartment_id varchar2(32767),
  target_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alerts_update_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_alerts_update_details_t (
    status varchar2,
    compartment_id varchar2,
    target_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to apply the discovery results to a sensitive data model.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_apply_discovery_job_results_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  discovery_job_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_apply_discovery_job_results_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_apply_discovery_job_results_details_t (
    discovery_job_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to apply the SDM masking policy difference to a masking policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_apply_sdm_masking_policy_difference_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  sdm_masking_policy_difference_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_apply_sdm_masking_policy_difference_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_apply_sdm_masking_policy_difference_details_t (
    sdm_masking_policy_difference_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents the archive retrieve request for the audit data. You can retrieve audit data for a target database from the archive and store it online. For more information, see Retrieve Audit Data for a Target Database from the Archive.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_archive_retrieval_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  start_date timestamp with time zone,
  end_date timestamp with time zone,
  target_id varchar2(32767),
  time_requested timestamp with time zone,
  time_completed timestamp with time zone,
  time_of_expiry timestamp with time zone,
  audit_event_count number,
  error_info varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_archive_retrieval_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_archive_retrieval_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    start_date timestamp with time zone,
    end_date timestamp with time zone,
    target_id varchar2,
    time_requested timestamp with time zone,
    time_completed timestamp with time zone,
    time_of_expiry timestamp with time zone,
    audit_event_count number,
    error_info varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary details of an archive retrieval.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_archive_retrieval_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  start_date timestamp with time zone,
  end_date timestamp with time zone,
  target_id varchar2(32767),
  time_requested timestamp with time zone,
  time_completed timestamp with time zone,
  time_of_expiry timestamp with time zone,
  audit_event_count number,
  error_info varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_archive_retrieval_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_archive_retrieval_summary_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    start_date timestamp with time zone,
    end_date timestamp with time zone,
    target_id varchar2,
    time_requested timestamp with time zone,
    time_completed timestamp with time zone,
    time_of_expiry timestamp with time zone,
    audit_event_count number,
    error_info varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_archive_retrieval_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_archive_retrieval_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_archive_retrieval_summary_t) NOT PERSISTABLE;

Collection of archive retrieval summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_archive_retrieval_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_archive_retrieval_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_archive_retrieval_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_archive_retrieval_collection_t (
    items dbms_cloud_oci_datasafe_audit_archive_retrieval_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of the audit policy provisioning conditions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_enable_conditions_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_selection varchar2(32767),
  entity_type varchar2(32767),
  operation_status varchar2(32767),
  entity_names dbms_cloud_oci_datasafe_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_enable_conditions_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_enable_conditions_t (
    entity_selection varchar2,
    entity_type varchar2,
    operation_status varchar2,
    entity_names dbms_cloud_oci_datasafe_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_enable_conditions_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_enable_conditions_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_enable_conditions_t) NOT PERSISTABLE;

Represents audit policies with corresponding audit provisioning conditions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_conditions_t FORCE AUTHID CURRENT_USER IS OBJECT (
  audit_policy_name varchar2(32767),
  is_priv_users_managed_by_data_safe number,
  is_data_safe_service_account_audited number,
  enable_conditions dbms_cloud_oci_datasafe_enable_conditions_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_conditions_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_conditions_t (
    audit_policy_name varchar2,
    is_priv_users_managed_by_data_safe number,
    is_data_safe_service_account_audited number,
    enable_conditions dbms_cloud_oci_datasafe_enable_conditions_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of the aggregation dimensions used for summarizing audit events.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_event_aggregation_dimensions_t FORCE AUTHID CURRENT_USER IS OBJECT (
  audit_event_time dbms_cloud_oci_datasafe_timestamp_with_time_zone_tbl,
  db_user_name dbms_cloud_oci_datasafe_varchar2_tbl,
  target_id dbms_cloud_oci_datasafe_varchar2_tbl,
  target_name dbms_cloud_oci_datasafe_varchar2_tbl,
  target_class dbms_cloud_oci_datasafe_varchar2_tbl,
  object_type dbms_cloud_oci_datasafe_varchar2_tbl,
  client_hostname dbms_cloud_oci_datasafe_varchar2_tbl,
  client_program dbms_cloud_oci_datasafe_varchar2_tbl,
  client_id dbms_cloud_oci_datasafe_varchar2_tbl,
  audit_type dbms_cloud_oci_datasafe_varchar2_tbl,
  event_name dbms_cloud_oci_datasafe_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_aggregation_dimensions_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_aggregation_dimensions_t (
    audit_event_time dbms_cloud_oci_datasafe_timestamp_with_time_zone_tbl,
    db_user_name dbms_cloud_oci_datasafe_varchar2_tbl,
    target_id dbms_cloud_oci_datasafe_varchar2_tbl,
    target_name dbms_cloud_oci_datasafe_varchar2_tbl,
    target_class dbms_cloud_oci_datasafe_varchar2_tbl,
    object_type dbms_cloud_oci_datasafe_varchar2_tbl,
    client_hostname dbms_cloud_oci_datasafe_varchar2_tbl,
    client_program dbms_cloud_oci_datasafe_varchar2_tbl,
    client_id dbms_cloud_oci_datasafe_varchar2_tbl,
    audit_type dbms_cloud_oci_datasafe_varchar2_tbl,
    event_name dbms_cloud_oci_datasafe_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of audit events aggregation items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_event_aggregation_items_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  metric_name varchar2(32767),
  time_started timestamp with time zone,
  time_ended timestamp with time zone,
  l_count number,
  dimensions dbms_cloud_oci_datasafe_audit_event_aggregation_dimensions_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_aggregation_items_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_aggregation_items_t (
    display_name varchar2,
    metric_name varchar2,
    time_started timestamp with time zone,
    time_ended timestamp with time zone,
    l_count number,
    dimensions dbms_cloud_oci_datasafe_audit_event_aggregation_dimensions_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_event_aggregation_items_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_event_aggregation_items_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_event_aggregation_items_t) NOT PERSISTABLE;

Audit events summarized detail.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_event_analytics_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_event_aggregation_items_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_analytics_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_analytics_collection_t (
    items dbms_cloud_oci_datasafe_audit_event_aggregation_items_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The resource represents the audit events collected from the target database by Oracle Data Safe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_event_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  db_user_name varchar2(32767),
  target_id varchar2(32767),
  target_name varchar2(32767),
  database_type varchar2(32767),
  target_class varchar2(32767),
  audit_event_time timestamp with time zone,
  time_collected timestamp with time zone,
  os_user_name varchar2(32767),
  operation varchar2(32767),
  operation_status varchar2(32767),
  event_name varchar2(32767),
  error_code varchar2(32767),
  error_message varchar2(32767),
  object_type varchar2(32767),
  object_name varchar2(32767),
  object_owner varchar2(32767),
  client_hostname varchar2(32767),
  client_ip varchar2(32767),
  audit_trail_id varchar2(32767),
  is_alerted number,
  action_taken varchar2(32767),
  client_program varchar2(32767),
  command_text varchar2(32767),
  command_param varchar2(32767),
  extended_event_attributes varchar2(32767),
  audit_location varchar2(32767),
  os_terminal varchar2(32767),
  client_id varchar2(32767),
  audit_policies varchar2(32767),
  audit_type varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_summary_t (
    id varchar2,
    compartment_id varchar2,
    db_user_name varchar2,
    target_id varchar2,
    target_name varchar2,
    database_type varchar2,
    target_class varchar2,
    audit_event_time timestamp with time zone,
    time_collected timestamp with time zone,
    os_user_name varchar2,
    operation varchar2,
    operation_status varchar2,
    event_name varchar2,
    error_code varchar2,
    error_message varchar2,
    object_type varchar2,
    object_name varchar2,
    object_owner varchar2,
    client_hostname varchar2,
    client_ip varchar2,
    audit_trail_id varchar2,
    is_alerted number,
    action_taken varchar2,
    client_program varchar2,
    command_text varchar2,
    command_param varchar2,
    extended_event_attributes varchar2,
    audit_location varchar2,
    os_terminal varchar2,
    client_id varchar2,
    audit_policies varchar2,
    audit_type varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_event_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_event_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_event_summary_t) NOT PERSISTABLE;

Collection of audit event summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_event_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_event_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_event_collection_t (
    items dbms_cloud_oci_datasafe_audit_event_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Represents an audit policy relevant for the target database.The audit policy could be in any one of the following 3 states in the target database 1) Created and enabled 2) Created but not enabled 3) Not created For more details on relevant audit policies for the target database, refer to documentation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_specification_t FORCE AUTHID CURRENT_USER IS OBJECT (
  audit_policy_name varchar2(32767),
  database_policy_names dbms_cloud_oci_datasafe_varchar2_tbl,
  audit_policy_category varchar2(32767),
  enable_status varchar2(32767),
  partially_enabled_msg varchar2(32767),
  is_enabled_for_all_users number,
  is_view_only number,
  is_seeded_in_target number,
  is_seeded_in_data_safe number,
  is_created number,
  enabled_entities varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_specification_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_specification_t (
    audit_policy_name varchar2,
    database_policy_names dbms_cloud_oci_datasafe_varchar2_tbl,
    audit_policy_category varchar2,
    enable_status varchar2,
    partially_enabled_msg varchar2,
    is_enabled_for_all_users number,
    is_view_only number,
    is_seeded_in_target number,
    is_seeded_in_data_safe number,
    is_created number,
    enabled_entities varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_specification_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_specification_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_specification_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_datasafe_audit_conditions_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_conditions_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_conditions_t) NOT PERSISTABLE;

The resource represents all available audit policies relevant for the target database with their corresponding audit conditions. The audit policies could be in any one of the following 3 states in the target database 1) Created and enabled 2) Created but not enabled 3) Not created For more details on available audit policies, refer to documentation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_policy_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  target_id varchar2(32767),
  is_data_safe_service_account_excluded number,
  time_last_provisioned timestamp with time zone,
  time_last_retrieved timestamp with time zone,
  audit_specifications dbms_cloud_oci_datasafe_audit_specification_tbl,
  audit_conditions dbms_cloud_oci_datasafe_audit_conditions_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    target_id varchar2,
    is_data_safe_service_account_excluded number,
    time_last_provisioned timestamp with time zone,
    time_last_retrieved timestamp with time zone,
    audit_specifications dbms_cloud_oci_datasafe_audit_specification_tbl,
    audit_conditions dbms_cloud_oci_datasafe_audit_conditions_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of aggregation dimensions used for summarizing audit policies.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_policy_dimensions_t FORCE AUTHID CURRENT_USER IS OBJECT (
  audit_policy_category varchar2(32767),
  audit_policy_name varchar2(32767),
  target_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_dimensions_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_dimensions_t (
    audit_policy_category varchar2,
    audit_policy_name varchar2,
    target_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of the audit profile aggregation items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_policy_aggregation_items_t FORCE AUTHID CURRENT_USER IS OBJECT (
  dimensions dbms_cloud_oci_datasafe_audit_policy_dimensions_t,
  l_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_aggregation_items_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_aggregation_items_t (
    dimensions dbms_cloud_oci_datasafe_audit_policy_dimensions_t,
    l_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_policy_aggregation_items_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_policy_aggregation_items_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_policy_aggregation_items_t) NOT PERSISTABLE;

Details of audit policy aggregation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_policy_analytic_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_policy_aggregation_items_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_analytic_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_analytic_collection_t (
    items dbms_cloud_oci_datasafe_audit_policy_aggregation_items_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The resource represents all available audit policies relevant for the target database with their corresponding audit conditions. The audit policies could be in any one of the following 3 states in the target database 1) Created and enabled 2) Created but not enabled 3) Not created For more details on available audit policies, refer to documentation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_policy_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  target_id varchar2(32767),
  is_data_safe_service_account_excluded number,
  audit_specifications dbms_cloud_oci_datasafe_audit_specification_tbl,
  time_last_provisioned timestamp with time zone,
  time_last_retrieved timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_summary_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    target_id varchar2,
    is_data_safe_service_account_excluded number,
    audit_specifications dbms_cloud_oci_datasafe_audit_specification_tbl,
    time_last_provisioned timestamp with time zone,
    time_last_retrieved timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_policy_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_policy_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_policy_summary_t) NOT PERSISTABLE;

Collection of audit policy summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_policy_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_policy_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_policy_collection_t (
    items dbms_cloud_oci_datasafe_audit_policy_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

An audit trail represents the source of audit records that provides documentary evidence of the sequence of activities in the target database. Configuring audit trails in Data Safe, and enabling audit data collection on the audit trails copies the audit records from the target database's audit trail into the Data Safe repository.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  audit_profile_id varchar2(32767),
  target_id varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  status varchar2(32767),
  lifecycle_details varchar2(32767),
  trail_location varchar2(32767),
  description varchar2(32767),
  is_auto_purge_enabled number,
  audit_collection_start_time timestamp with time zone,
  work_request_id varchar2(32767),
  compartment_id varchar2(32767),
  time_last_collected timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_t (
    id varchar2,
    audit_profile_id varchar2,
    target_id varchar2,
    display_name varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    status varchar2,
    lifecycle_details varchar2,
    trail_location varchar2,
    description varchar2,
    is_auto_purge_enabled number,
    audit_collection_start_time timestamp with time zone,
    work_request_id varchar2,
    compartment_id varchar2,
    time_last_collected timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_trail_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_trail_t) NOT PERSISTABLE;

The resource represents audit profile settings and audit configurations for the database target, and helps evaluate the initial audit data volume for configuring collection in Data Safe. The resource is also responsible for auto-discovery of audit trails in the database target during target's registration.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_profile_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  target_id varchar2(32767),
  description varchar2(32767),
  audit_trails dbms_cloud_oci_datasafe_audit_trail_tbl,
  is_paid_usage_enabled number,
  online_months number,
  offline_months number,
  audit_collected_volume number,
  is_override_global_retention_setting number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    target_id varchar2,
    description varchar2,
    audit_trails dbms_cloud_oci_datasafe_audit_trail_tbl,
    is_paid_usage_enabled number,
    online_months number,
    offline_months number,
    audit_collected_volume number,
    is_override_global_retention_setting number,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of aggregation dimensions used for summarizing audit profiles.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_profile_dimensions_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_paid_usage_enabled number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_dimensions_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_dimensions_t (
    is_paid_usage_enabled number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of audit profile aggregation items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_profile_aggregation_items_t FORCE AUTHID CURRENT_USER IS OBJECT (
  dimensions dbms_cloud_oci_datasafe_audit_profile_dimensions_t,
  l_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_aggregation_items_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_aggregation_items_t (
    dimensions dbms_cloud_oci_datasafe_audit_profile_dimensions_t,
    l_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_profile_aggregation_items_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_profile_aggregation_items_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_profile_aggregation_items_t) NOT PERSISTABLE;

Details of audit profile analytic summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_profile_analytic_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_profile_aggregation_items_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_analytic_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_analytic_collection_t (
    items dbms_cloud_oci_datasafe_audit_profile_aggregation_items_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of an audit profile.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_profile_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  target_id varchar2(32767),
  lifecycle_state varchar2(32767),
  description varchar2(32767),
  lifecycle_details varchar2(32767),
  is_paid_usage_enabled number,
  online_months number,
  offline_months number,
  audit_collected_volume number,
  is_override_global_retention_setting number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_summary_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    target_id varchar2,
    lifecycle_state varchar2,
    description varchar2,
    lifecycle_details varchar2,
    is_paid_usage_enabled number,
    online_months number,
    offline_months number,
    audit_collected_volume number,
    is_override_global_retention_setting number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_profile_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_profile_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_profile_summary_t) NOT PERSISTABLE;

Collection of audit profile summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_profile_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_profile_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_profile_collection_t (
    items dbms_cloud_oci_datasafe_audit_profile_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of aggregation dimensions used for summarizing audit trails.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_dimensions_t FORCE AUTHID CURRENT_USER IS OBJECT (
  location varchar2(32767),
  lifecycle_state varchar2(32767),
  status varchar2(32767),
  target_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_dimensions_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_dimensions_t (
    location varchar2,
    lifecycle_state varchar2,
    status varchar2,
    target_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of audit trail aggregation items.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_aggregation_items_t FORCE AUTHID CURRENT_USER IS OBJECT (
  dimensions dbms_cloud_oci_datasafe_audit_trail_dimensions_t,
  l_count number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_aggregation_items_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_aggregation_items_t (
    dimensions dbms_cloud_oci_datasafe_audit_trail_dimensions_t,
    l_count number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_trail_aggregation_items_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_aggregation_items_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_trail_aggregation_items_t) NOT PERSISTABLE;

Details of audit trail analytic summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_analytic_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_trail_aggregation_items_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_analytic_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_analytic_collection_t (
    items dbms_cloud_oci_datasafe_audit_trail_aggregation_items_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of an audit trail.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  audit_profile_id varchar2(32767),
  display_name varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  status varchar2(32767),
  description varchar2(32767),
  trail_location varchar2(32767),
  compartment_id varchar2(32767),
  target_id varchar2(32767),
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  is_auto_purge_enabled number,
  audit_collection_start_time timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_summary_t (
    id varchar2,
    audit_profile_id varchar2,
    display_name varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    status varchar2,
    description varchar2,
    trail_location varchar2,
    compartment_id varchar2,
    target_id varchar2,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    is_auto_purge_enabled number,
    audit_collection_start_time timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_audit_trail_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_audit_trail_summary_t) NOT PERSISTABLE;

Collection of audit trail detail objects.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_audit_trail_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_audit_trail_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_audit_trail_collection_t (
    items dbms_cloud_oci_datasafe_audit_trail_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the database for the registration in Data Safe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_database_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  database_type varchar2(32767),
  infrastructure_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_details_t (
    database_type varchar2,
    infrastructure_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The details of the Autonomous Database to be registered as a target database in Data Safe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_autonomous_database_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_database_details_t (
  autonomous_database_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_autonomous_database_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_autonomous_database_details_t (
    database_type varchar2,
    infrastructure_type varchar2,
    autonomous_database_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_autonomous_database_details_t is a subtype of the dbms_cloud_oci_datasafe_database_details_t type.

Fields

Represents the audit data volume collected by Data Safe from the target database for the specified audit profile.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_available_audit_volume_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  audit_profile_id varchar2(32767),
  trail_location varchar2(32767),
  month_in_consideration timestamp with time zone,
  volume number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_available_audit_volume_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_available_audit_volume_summary_t (
    audit_profile_id varchar2,
    trail_location varchar2,
    month_in_consideration timestamp with time zone,
    volume number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_available_audit_volume_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_available_audit_volume_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_available_audit_volume_summary_t) NOT PERSISTABLE;

Collection of available audit volume summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_available_audit_volume_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_available_audit_volume_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_available_audit_volume_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_available_audit_volume_collection_t (
    items dbms_cloud_oci_datasafe_available_audit_volume_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details for calculating audit data volume on target.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_calculate_audit_volume_available_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  audit_collection_start_time timestamp with time zone,
  trail_locations dbms_cloud_oci_datasafe_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_calculate_audit_volume_available_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_calculate_audit_volume_available_details_t (
    audit_collection_start_time timestamp with time zone,
    trail_locations dbms_cloud_oci_datasafe_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details for calculating audit data volume collected by data safe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_calculate_audit_volume_collected_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  time_from_month timestamp with time zone,
  time_to_month timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_calculate_audit_volume_collected_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_calculate_audit_volume_collected_details_t (
    time_from_month timestamp with time zone,
    time_to_month timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to change the compartment of an alert.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_alert_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_alert_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_alert_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to change the compartment of an alert policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_alert_policy_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_alert_policy_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_alert_policy_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The description of the achieve retrieval change compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_audit_archive_retrieval_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_audit_archive_retrieval_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_audit_archive_retrieval_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for which compartment to move the resource to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_audit_policy_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_audit_policy_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_audit_policy_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Moves the specified audit profile and its assoicated resources into a different compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_audit_profile_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_audit_profile_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_audit_profile_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to change the compartment of a Data Safe private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_data_safe_private_endpoint_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_data_safe_private_endpoint_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_data_safe_private_endpoint_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details for which compartment to move the resource to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_database_security_config_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_database_security_config_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_database_security_config_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to change the compartment of a discovery job resource.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_discovery_job_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_discovery_job_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_discovery_job_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to change the compartment of a library masking format.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_library_masking_format_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_library_masking_format_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_library_masking_format_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to change the compartment of a masking policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_masking_policy_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_masking_policy_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_masking_policy_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to change the compartment of a on-premises connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_on_prem_connector_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_on_prem_connector_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_on_prem_connector_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of the compartment that the audit report is moving to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_report_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_report_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_report_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for which compartment to move the resource to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_report_definition_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_report_definition_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_report_definition_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for the audit retention months to be modified.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_retention_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  online_months number,
  offline_months number,
  is_override_global_retention_setting number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_retention_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_retention_details_t (
    online_months number,
    offline_months number,
    is_override_global_retention_setting number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to change the compartment of a SDM masking policy difference.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_sdm_masking_policy_difference_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sdm_masking_policy_difference_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sdm_masking_policy_difference_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details that can be changed (or retained) when a security assessment is moved to another compartment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_security_assessment_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_security_assessment_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_security_assessment_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for which compartment to move the resource to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_security_policy_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_security_policy_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_security_policy_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for which compartment to move the resource to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_security_policy_deployment_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_security_policy_deployment_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_security_policy_deployment_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to change the compartment of a sensitive data model.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_sensitive_data_model_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sensitive_data_model_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sensitive_data_model_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to change the compartment of a sensitive type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_sensitive_type_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sensitive_type_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sensitive_type_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for which compartment to move the resource to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_sql_collection_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sql_collection_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sql_collection_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for which compartment to move the resource to.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_sql_firewall_policy_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sql_firewall_policy_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_sql_firewall_policy_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to change the compartment of a target-alert policy association.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_target_alert_policy_association_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_target_alert_policy_association_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_target_alert_policy_association_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to change the compartment of a Data Safe target database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_target_database_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_target_database_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_target_database_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to change the compartment of the user assessment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_change_user_assessment_compartment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_user_assessment_compartment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_change_user_assessment_compartment_details_t (
    compartment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The volume data point for audit data collected by datasafe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_collected_audit_volume_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  audit_profile_id varchar2(32767),
  month_in_consideration timestamp with time zone,
  online_volume number,
  archived_volume number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_collected_audit_volume_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_collected_audit_volume_summary_t (
    audit_profile_id varchar2,
    month_in_consideration timestamp with time zone,
    online_volume number,
    archived_volume number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_collected_audit_volume_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_collected_audit_volume_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_collected_audit_volume_summary_t) NOT PERSISTABLE;

Collection of collected audit volume summary.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_collected_audit_volume_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_collected_audit_volume_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_collected_audit_volume_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_collected_audit_volume_collection_t (
    items dbms_cloud_oci_datasafe_collected_audit_volume_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The source of masking columns.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_source_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  column_source varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_source_details_t (
    column_source varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Details of the sensitive data model that's used as the source of masking columns..

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_source_from_sdm_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_column_source_details_t (
  sensitive_data_model_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_source_from_sdm_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_source_from_sdm_details_t (
    column_source varchar2,
    sensitive_data_model_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_column_source_from_sdm_details_t is a subtype of the dbms_cloud_oci_datasafe_column_source_details_t type.

Fields

Details of the target database that's used as the source of masking columns.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_source_from_target_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_column_source_details_t (
  target_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_source_from_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_source_from_target_details_t (
    column_source varchar2,
    target_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_column_source_from_target_details_t is a subtype of the dbms_cloud_oci_datasafe_column_source_details_t type.

Fields

The details of a column in a table fetched from the database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  column_name varchar2(32767),
  data_type varchar2(32767),
  length number,
  precision number,
  scale number,
  character_length number,
  table_name varchar2(32767),
  schema_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_summary_t (
    column_name varchar2,
    data_type varchar2,
    length number,
    precision number,
    scale number,
    character_length number,
    table_name varchar2,
    schema_name varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details specifying the security assessment used for comparison.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_compare_security_assessment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  comparison_security_assessment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_compare_security_assessment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_compare_security_assessment_details_t (
    comparison_security_assessment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of the user assessment comparison.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_compare_user_assessment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  comparison_user_assessment_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_compare_user_assessment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_compare_user_assessment_details_t (
    comparison_user_assessment_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a masking format.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_format_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  name varchar2(32767),
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_format_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_format_summary_t (
    id varchar2,
    name varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_format_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_format_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_format_summary_t) NOT PERSISTABLE;

A list of basic masking formats compatible with a supported data type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_formats_for_data_type_t FORCE AUTHID CURRENT_USER IS OBJECT (
  data_type varchar2(32767),
  masking_formats dbms_cloud_oci_datasafe_format_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_formats_for_data_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_formats_for_data_type_t (
    data_type varchar2,
    masking_formats dbms_cloud_oci_datasafe_format_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_formats_for_data_type_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_formats_for_data_type_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_formats_for_data_type_t) NOT PERSISTABLE;

A list of basic masking formats compatible with and grouped by the supported data types. The data types are grouped into the following categories - Character - Includes CHAR, NCHAR, VARCHAR2, and NVARCHAR2 Numeric - Includes NUMBER, FLOAT, RAW, BINARY_FLOAT, and BINARY_DOUBLE Date - Includes DATE and TIMESTAMP LOB - Includes BLOB, CLOB, and NCLOB All - Includes all the supported data types

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_compatible_formats_for_data_types_t FORCE AUTHID CURRENT_USER IS OBJECT (
  formats_for_data_type dbms_cloud_oci_datasafe_formats_for_data_type_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_compatible_formats_for_data_types_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_compatible_formats_for_data_types_t (
    formats_for_data_type dbms_cloud_oci_datasafe_formats_for_data_type_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A list of library masking formats compatible with an existing sensitive type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_formats_for_sensitive_type_t FORCE AUTHID CURRENT_USER IS OBJECT (
  sensitive_type_id varchar2(32767),
  masking_formats dbms_cloud_oci_datasafe_format_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_formats_for_sensitive_type_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_formats_for_sensitive_type_t (
    sensitive_type_id varchar2,
    masking_formats dbms_cloud_oci_datasafe_format_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_formats_for_sensitive_type_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_formats_for_sensitive_type_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_formats_for_sensitive_type_t) NOT PERSISTABLE;

The list of compatible masking formats grouped by generic sensitive types.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_compatible_formats_for_sensitive_types_t FORCE AUTHID CURRENT_USER IS OBJECT (
  formats_for_sensitive_type dbms_cloud_oci_datasafe_formats_for_sensitive_type_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_compatible_formats_for_sensitive_types_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_compatible_formats_for_sensitive_types_t (
    formats_for_sensitive_type dbms_cloud_oci_datasafe_formats_for_sensitive_type_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Types of connection supported by Data Safe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_connection_option_t FORCE AUTHID CURRENT_USER IS OBJECT (
  connection_type varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_connection_option_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_connection_option_t (
    connection_type varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

The details used to create a new alert policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_alert_policy_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  alert_policy_type varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  severity varchar2(32767),
  compartment_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_alert_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_alert_policy_details_t (
    alert_policy_type varchar2,
    display_name varchar2,
    description varchar2,
    severity varchar2,
    compartment_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to create a new alert policy rule.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_alert_policy_rule_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  expression varchar2(32767),
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_alert_policy_rule_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_alert_policy_rule_details_t (
    expression varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Request details for creating a new archive retrieval.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_audit_archive_retrieval_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  target_id varchar2(32767),
  start_date timestamp with time zone,
  end_date timestamp with time zone,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_audit_archive_retrieval_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_audit_archive_retrieval_details_t (
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    target_id varchar2,
    start_date timestamp with time zone,
    end_date timestamp with time zone,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details for the new audit policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_audit_policy_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  target_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_audit_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_audit_policy_details_t (
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    target_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to create a new audit profile.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_audit_profile_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  target_id varchar2(32767),
  description varchar2(32767),
  is_paid_usage_enabled number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_audit_profile_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_audit_profile_details_t (
    display_name varchar2,
    compartment_id varchar2,
    target_id varchar2,
    description varchar2,
    is_paid_usage_enabled number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to associate a column source with a masking policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_column_source_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  column_source varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_column_source_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_column_source_details_t (
    column_source varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Details of the sensitive data model to be associated as the column source with a masking policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_column_source_from_sdm_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_create_column_source_details_t (
  sensitive_data_model_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_column_source_from_sdm_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_column_source_from_sdm_details_t (
    column_source varchar2,
    sensitive_data_model_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_create_column_source_from_sdm_details_t is a subtype of the dbms_cloud_oci_datasafe_create_column_source_details_t type.

Fields

Details of the target database to be associated as the column source with a masking policy.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_column_source_from_target_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_create_column_source_details_t (
  target_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_column_source_from_target_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_column_source_from_target_details_t (
    column_source varchar2,
    target_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_create_column_source_from_target_details_t is a subtype of the dbms_cloud_oci_datasafe_create_column_source_details_t type.

Fields

The details used to create the new Data Safe private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_data_safe_private_endpoint_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  private_endpoint_ip varchar2(32767),
  description varchar2(32767),
  nsg_ids dbms_cloud_oci_datasafe_varchar2_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_data_safe_private_endpoint_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_data_safe_private_endpoint_details_t (
    display_name varchar2,
    compartment_id varchar2,
    vcn_id varchar2,
    subnet_id varchar2,
    private_endpoint_ip varchar2,
    description varchar2,
    nsg_ids dbms_cloud_oci_datasafe_varchar2_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to create a new data discovery job.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_discovery_job_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  discovery_type varchar2(32767),
  sensitive_data_model_id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  schemas_for_discovery dbms_cloud_oci_datasafe_varchar2_tbl,
  sensitive_type_ids_for_discovery dbms_cloud_oci_datasafe_varchar2_tbl,
  is_sample_data_collection_enabled number,
  is_app_defined_relation_discovery_enabled number,
  is_include_all_schemas number,
  is_include_all_sensitive_types number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_discovery_job_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_discovery_job_details_t (
    discovery_type varchar2,
    sensitive_data_model_id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    schemas_for_discovery dbms_cloud_oci_datasafe_varchar2_tbl,
    sensitive_type_ids_for_discovery dbms_cloud_oci_datasafe_varchar2_tbl,
    is_sample_data_collection_enabled number,
    is_app_defined_relation_discovery_enabled number,
    is_include_all_schemas number,
    is_include_all_sensitive_types number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A format entry is part of a masking format and defines the logic to mask data. A format entry can be a basic masking format such as Random Number, or it can be a library masking format. If a masking format has more than one format entries, the combined output of all the format entries is used for masking.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_format_entry_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_type varchar2(32767),
  description varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_format_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_format_entry_t (
    l_type varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Nested table type of dbms_cloud_oci_datasafe_format_entry_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_format_entry_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_format_entry_t) NOT PERSISTABLE;

Details to create a library masking format, which can have one or more format entries. A format entry can be a basic masking format such as Random Number, or it can be a library masking format. The combined output of all the format entries is used for masking. It provides the flexibility to define a masking format that can generate different parts of a data value separately and then combine them to get the final data value for masking. Note that you cannot define masking condition in a library masking format.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_library_masking_format_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  description varchar2(32767),
  sensitive_type_ids dbms_cloud_oci_datasafe_varchar2_tbl,
  format_entries dbms_cloud_oci_datasafe_format_entry_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_library_masking_format_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_library_masking_format_details_t (
    display_name varchar2,
    compartment_id varchar2,
    description varchar2,
    sensitive_type_ids dbms_cloud_oci_datasafe_varchar2_tbl,
    format_entries dbms_cloud_oci_datasafe_format_entry_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A masking format defines the logic to mask data in a database column. The condition attribute defines the condition that must be true for applying the masking format. It enables you to do <a href=\"https://docs.oracle.com/en/cloud/paas/data-safe/udscs/conditional-masking.html\">conditional masking</a> so that you can mask the column data values differently using different masking formats and the associated conditions. A masking format can have one or more format entries. A format entry can be a basic masking format such as Random Number, or it can be a library masking format.The combined output of all the format entries is used for masking. It provides the flexibility to define a masking format that can generate different parts of a data value separately and then combine them to get the final data value for masking.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_masking_format_t FORCE AUTHID CURRENT_USER IS OBJECT (
  condition varchar2(32767),
  description varchar2(32767),
  format_entries dbms_cloud_oci_datasafe_format_entry_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_masking_format_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_masking_format_t (
    condition varchar2,
    description varchar2,
    format_entries dbms_cloud_oci_datasafe_format_entry_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_masking_format_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_masking_format_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_masking_format_t) NOT PERSISTABLE;

Details to create a new masking column. You can use this to add a parent column only. It automatically adds the child columns from the associated sensitive data model or target database. If you provide the sensitiveTypeId attribute but not the maskingFormats attribute, it automatically assigns the default masking format associated with the specified sensitive type. Alternatively, if you provide the maskingFormats attribute, the specified masking formats are assigned to the column. Using the maskingFormats attribute, you can assign one or more masking formats to a column. You can specify a condition as part of each masking format. It enables you to do <a href=\"https://docs.oracle.com/en/cloud/paas/data-safe/udscs/conditional-masking.html\">conditional masking</a> so that you can mask the column data values differently using different masking formats and the associated conditions. A masking format can have one or more format entries. The combined output of all the format entries is used for masking. It provides the flexibility to define a masking format that can generate different parts of a data value separately and then combine them to get the final data value for masking. You can use the maskingColumnGroup attribute to group the columns that you would like to mask together. It enables you to do <a href=\"https://docs.oracle.com/en/cloud/paas/data-safe/udscs/group-masking1.html#GUID-755056B9-9540-48C0-9491-262A44A85037\">group or compound masking</a> that ensures that the masked data across the columns in a group continue to retain the same logical relationship.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_masking_column_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  schema_name varchar2(32767),
  object_name varchar2(32767),
  object_type varchar2(32767),
  column_name varchar2(32767),
  masking_column_group varchar2(32767),
  sensitive_type_id varchar2(32767),
  is_masking_enabled number,
  masking_formats dbms_cloud_oci_datasafe_masking_format_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_masking_column_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_masking_column_details_t (
    schema_name varchar2,
    object_name varchar2,
    object_type varchar2,
    column_name varchar2,
    masking_column_group varchar2,
    sensitive_type_id varchar2,
    is_masking_enabled number,
    masking_formats dbms_cloud_oci_datasafe_masking_format_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to create a new masking policy. Use either a sensitive data model or a reference target database to create your masking policy. To use a sensitive data model as the source of masking columns, set the columnSource attribute to SENSITIVE_DATA_MODEL and provide the sensitiveDataModelId attribute. After creating a masking policy, you can use the AddMaskingColumnsFromSdm operation to automatically add all the columns from the associated sensitive data model. In this case, the target database associated with the sensitive data model is used for column and masking format validations. You can also create a masking policy without using a sensitive data model. In this case, you need to associate your masking policy with a target database by setting the columnSource attribute to TARGET and providing the targetId attribute. The specified target database is used for column and masking format validations. After creating a masking policy, you can use the CreateMaskingColumn or PatchMaskingColumns operation to manually add columns to the policy. You need to add the parent columns only, and it automatically adds the child columns (in referential relationship with the parent columns) from the associated sensitive data model or target database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_masking_policy_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  description varchar2(32767),
  is_drop_temp_tables_enabled number,
  is_redo_logging_enabled number,
  is_refresh_stats_enabled number,
  parallel_degree varchar2(32767),
  recompile varchar2(32767),
  pre_masking_script varchar2(32767),
  post_masking_script varchar2(32767),
  column_source dbms_cloud_oci_datasafe_create_column_source_details_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_masking_policy_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_masking_policy_details_t (
    display_name varchar2,
    compartment_id varchar2,
    description varchar2,
    is_drop_temp_tables_enabled number,
    is_redo_logging_enabled number,
    is_refresh_stats_enabled number,
    parallel_degree varchar2,
    recompile varchar2,
    pre_masking_script varchar2,
    post_masking_script varchar2,
    column_source dbms_cloud_oci_datasafe_create_column_source_details_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to create a new on-premises connector.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_on_prem_connector_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  description varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_on_prem_connector_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_on_prem_connector_details_t (
    display_name varchar2,
    compartment_id varchar2,
    description varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The description of the column.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  field_name varchar2(32767),
  data_type varchar2(32767),
  is_hidden number,
  display_order number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_t (
    display_name varchar2,
    field_name varchar2,
    data_type varchar2,
    is_hidden number,
    display_order number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Filters that are applied to the data at the column level.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_filter_t FORCE AUTHID CURRENT_USER IS OBJECT (
  field_name varchar2(32767),
  operator varchar2(32767),
  expressions dbms_cloud_oci_datasafe_varchar2_tbl,
  is_enabled number,
  is_hidden number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_filter_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_filter_t (
    field_name varchar2,
    operator varchar2,
    expressions dbms_cloud_oci_datasafe_varchar2_tbl,
    is_enabled number,
    is_hidden number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Sorts the data at the column level.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_sorting_t FORCE AUTHID CURRENT_USER IS OBJECT (
  field_name varchar2(32767),
  is_ascending number,
  sorting_order number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_sorting_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_column_sorting_t (
    field_name varchar2,
    is_ascending number,
    sorting_order number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of the audit report.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  name varchar2(32767),
  is_hidden number,
  display_order number,
  group_by_field_name varchar2(32767),
  count_of varchar2(32767),
  scim_filter varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_summary_t (
    name varchar2,
    is_hidden number,
    display_order number,
    group_by_field_name varchar2,
    count_of varchar2,
    scim_filter varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_column_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_column_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_datasafe_column_filter_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_filter_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_column_filter_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_datasafe_column_sorting_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_column_sorting_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_column_sorting_t) NOT PERSISTABLE;

Nested table type of dbms_cloud_oci_datasafe_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_summary_t) NOT PERSISTABLE;

Description of a new report definition.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_report_definition_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  parent_id varchar2(32767),
  description varchar2(32767),
  column_info dbms_cloud_oci_datasafe_column_tbl,
  column_filters dbms_cloud_oci_datasafe_column_filter_tbl,
  column_sortings dbms_cloud_oci_datasafe_column_sorting_tbl,
  summary dbms_cloud_oci_datasafe_summary_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_report_definition_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_report_definition_details_t (
    compartment_id varchar2,
    display_name varchar2,
    parent_id varchar2,
    description varchar2,
    column_info dbms_cloud_oci_datasafe_column_tbl,
    column_filters dbms_cloud_oci_datasafe_column_filter_tbl,
    column_sortings dbms_cloud_oci_datasafe_column_sorting_tbl,
    summary dbms_cloud_oci_datasafe_summary_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to create a new SDM masking policy difference.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_sdm_masking_policy_difference_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  difference_type varchar2(32767),
  masking_policy_id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sdm_masking_policy_difference_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sdm_masking_policy_difference_details_t (
    difference_type varchar2,
    masking_policy_id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to save a security assessment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_security_assessment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  target_id varchar2(32767),
  schedule varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_security_assessment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_security_assessment_details_t (
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    target_id varchar2,
    schedule varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to create a new sensitive type.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_sensitive_type_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  entity_type varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  short_name varchar2(32767),
  description varchar2(32767),
  parent_category_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_type_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_type_details_t (
    entity_type varchar2,
    display_name varchar2,
    compartment_id varchar2,
    short_name varchar2,
    description varchar2,
    parent_category_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE NOT FINAL;

Fields

Details to create a new sensitive category.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_sensitive_category_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_create_sensitive_type_details_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_category_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_category_details_t (
    entity_type varchar2,
    display_name varchar2,
    compartment_id varchar2,
    short_name varchar2,
    description varchar2,
    parent_category_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_create_sensitive_category_details_t is a subtype of the dbms_cloud_oci_datasafe_create_sensitive_type_details_t type.

Details to create a new sensitive column in a sensitive data model.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_sensitive_column_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  app_name varchar2(32767),
  schema_name varchar2(32767),
  object_name varchar2(32767),
  column_name varchar2(32767),
  object_type varchar2(32767),
  data_type varchar2(32767),
  status varchar2(32767),
  sensitive_type_id varchar2(32767),
  parent_column_keys dbms_cloud_oci_datasafe_varchar2_tbl,
  relation_type varchar2(32767),
  app_defined_child_column_keys dbms_cloud_oci_datasafe_varchar2_tbl,
  db_defined_child_column_keys dbms_cloud_oci_datasafe_varchar2_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_column_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_column_details_t (
    app_name varchar2,
    schema_name varchar2,
    object_name varchar2,
    column_name varchar2,
    object_type varchar2,
    data_type varchar2,
    status varchar2,
    sensitive_type_id varchar2,
    parent_column_keys dbms_cloud_oci_datasafe_varchar2_tbl,
    relation_type varchar2,
    app_defined_child_column_keys dbms_cloud_oci_datasafe_varchar2_tbl,
    db_defined_child_column_keys dbms_cloud_oci_datasafe_varchar2_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to create a new sensitive data model. If schemas and sensitive types are provided, it automatically runs data discovery and adds the discovered columns to the sensitive data model. Otherwise, it creates an empty sensitive data model that can be updated later. To specify some schemas and sensitive types for data discovery, use schemasForDiscovery and sensitiveTypeIdsForDiscovery attributes. But if you want to include all schemas and sensitive types, you can set isIncludeAllSchemas and isIncludeAllSensitiveTypes attributes to true. In the latter case, you do not need to list all schemas and sensitive types.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_sensitive_data_model_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  target_id varchar2(32767),
  app_suite_name varchar2(32767),
  description varchar2(32767),
  schemas_for_discovery dbms_cloud_oci_datasafe_varchar2_tbl,
  sensitive_type_ids_for_discovery dbms_cloud_oci_datasafe_varchar2_tbl,
  is_sample_data_collection_enabled number,
  is_app_defined_relation_discovery_enabled number,
  is_include_all_schemas number,
  is_include_all_sensitive_types number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_data_model_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_data_model_details_t (
    display_name varchar2,
    compartment_id varchar2,
    target_id varchar2,
    app_suite_name varchar2,
    description varchar2,
    schemas_for_discovery dbms_cloud_oci_datasafe_varchar2_tbl,
    sensitive_type_ids_for_discovery dbms_cloud_oci_datasafe_varchar2_tbl,
    is_sample_data_collection_enabled number,
    is_app_defined_relation_discovery_enabled number,
    is_include_all_schemas number,
    is_include_all_sensitive_types number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details to create a new sensitive type with regular expressions.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_sensitive_type_pattern_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_create_sensitive_type_details_t (
  name_pattern varchar2(32767),
  comment_pattern varchar2(32767),
  data_pattern varchar2(32767),
  search_type varchar2(32767),
  default_masking_format_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_type_pattern_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sensitive_type_pattern_details_t (
    entity_type varchar2,
    display_name varchar2,
    compartment_id varchar2,
    short_name varchar2,
    description varchar2,
    parent_category_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    name_pattern varchar2,
    comment_pattern varchar2,
    data_pattern varchar2,
    search_type varchar2,
    default_masking_format_id varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_create_sensitive_type_pattern_details_t is a subtype of the dbms_cloud_oci_datasafe_create_sensitive_type_details_t type.

Fields

Details for SQL collection creation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_sql_collection_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  target_id varchar2(32767),
  status varchar2(32767),
  db_user_name varchar2(32767),
  sql_level varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sql_collection_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_sql_collection_details_t (
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    target_id varchar2,
    status varchar2,
    db_user_name varchar2,
    sql_level varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to create a new target-alert policy association.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_target_alert_policy_association_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  policy_id varchar2(32767),
  target_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  compartment_id varchar2(32767),
  is_enabled number,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_target_alert_policy_association_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_target_alert_policy_association_details_t (
    policy_id varchar2,
    target_id varchar2,
    display_name varchar2,
    description varchar2,
    compartment_id varchar2,
    is_enabled number,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to establish a TLS enabled connection.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_tls_config_t FORCE AUTHID CURRENT_USER IS OBJECT (
  status varchar2(32767),
  certificate_store_type varchar2(32767),
  store_password varchar2(32767),
  trust_store_content varchar2(32767),
  key_store_content varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_tls_config_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_tls_config_t (
    status varchar2,
    certificate_store_type varchar2,
    store_password varchar2,
    trust_store_content varchar2,
    key_store_content varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details used to register the database in Data Safe and to create the Data Safe target database.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_target_database_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  database_details dbms_cloud_oci_datasafe_database_details_t,
  credentials dbms_cloud_oci_datasafe_credentials_t,
  tls_config dbms_cloud_oci_datasafe_tls_config_t,
  connection_option dbms_cloud_oci_datasafe_connection_option_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_target_database_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_target_database_details_t (
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    database_details dbms_cloud_oci_datasafe_database_details_t,
    credentials dbms_cloud_oci_datasafe_credentials_t,
    tls_config dbms_cloud_oci_datasafe_tls_config_t,
    connection_option dbms_cloud_oci_datasafe_connection_option_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details required to save a user assessment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_create_user_assessment_details_t FORCE AUTHID CURRENT_USER IS OBJECT (
  compartment_id varchar2(32767),
  description varchar2(32767),
  display_name varchar2(32767),
  schedule varchar2(32767),
  target_id varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_user_assessment_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_create_user_assessment_details_t (
    compartment_id varchar2,
    description varchar2,
    display_name varchar2,
    schedule varchar2,
    target_id varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Details of the tenancy level global settings in Data Safe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_global_settings_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_paid_usage number,
  online_retention_period number,
  offline_retention_period number,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_global_settings_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_global_settings_t (
    is_paid_usage number,
    online_retention_period number,
    offline_retention_period number
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A Data Safe configuration for a tenancy and region.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_data_safe_configuration_t FORCE AUTHID CURRENT_USER IS OBJECT (
  is_enabled number,
  url varchar2(32767),
  compartment_id varchar2(32767),
  time_enabled timestamp with time zone,
  lifecycle_state varchar2(32767),
  data_safe_nat_gateway_ip_address varchar2(32767),
  global_settings dbms_cloud_oci_datasafe_global_settings_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_data_safe_configuration_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_data_safe_configuration_t (
    is_enabled number,
    url varchar2,
    compartment_id varchar2,
    time_enabled timestamp with time zone,
    lifecycle_state varchar2,
    data_safe_nat_gateway_ip_address varchar2,
    global_settings dbms_cloud_oci_datasafe_global_settings_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

A Data Safe private endpoint that allows Data Safe to connect to databases in a customer's virtual cloud network (VCN).

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_data_safe_private_endpoint_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  private_endpoint_id varchar2(32767),
  private_endpoint_ip varchar2(32767),
  endpoint_fqdn varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  nsg_ids dbms_cloud_oci_datasafe_varchar2_tbl,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_data_safe_private_endpoint_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_data_safe_private_endpoint_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    vcn_id varchar2,
    subnet_id varchar2,
    private_endpoint_id varchar2,
    private_endpoint_ip varchar2,
    endpoint_fqdn varchar2,
    description varchar2,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    nsg_ids dbms_cloud_oci_datasafe_varchar2_tbl,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a Data Safe private endpoint.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_data_safe_private_endpoint_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  display_name varchar2(32767),
  compartment_id varchar2(32767),
  vcn_id varchar2(32767),
  subnet_id varchar2(32767),
  private_endpoint_id varchar2(32767),
  description varchar2(32767),
  time_created timestamp with time zone,
  lifecycle_state varchar2(32767),
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_data_safe_private_endpoint_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_data_safe_private_endpoint_summary_t (
    id varchar2,
    display_name varchar2,
    compartment_id varchar2,
    vcn_id varchar2,
    subnet_id varchar2,
    private_endpoint_id varchar2,
    description varchar2,
    time_created timestamp with time zone,
    lifecycle_state varchar2,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The details of the cloud database to be registered as a target database in Data Safe.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_database_cloud_service_details_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_database_details_t (
  vm_cluster_id varchar2(32767),
  db_system_id varchar2(32767),
  listener_port number,
  service_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_cloud_service_details_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_cloud_service_details_t (
    database_type varchar2,
    infrastructure_type varchar2,
    vm_cluster_id varchar2,
    db_system_id varchar2,
    listener_port number,
    service_name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_database_cloud_service_details_t is a subtype of the dbms_cloud_oci_datasafe_database_details_t type.

Fields

The SQL Firewall related configurations.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_sql_firewall_config_t FORCE AUTHID CURRENT_USER IS OBJECT (
  status varchar2(32767),
  violation_log_auto_purge varchar2(32767),
  exclude_job varchar2(32767),
  time_status_updated timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_sql_firewall_config_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_sql_firewall_config_t (
    status varchar2,
    violation_log_auto_purge varchar2,
    exclude_job varchar2,
    time_status_updated timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database Security Configurations resource represents the target database configurations. Included in the Database Security Configurations are the SQL Firewall configurations such as the status of the firewall, the time that the firewall status was last updated, violation log auto purge settings, etc.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_database_security_config_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  target_id varchar2(32767),
  time_last_refreshed timestamp with time zone,
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  sql_firewall_config dbms_cloud_oci_datasafe_sql_firewall_config_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  system_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_security_config_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_security_config_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    target_id varchar2,
    time_last_refreshed timestamp with time zone,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    sql_firewall_config dbms_cloud_oci_datasafe_sql_firewall_config_t,
    freeform_tags json_element_t,
    defined_tags json_element_t,
    system_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Database Security Configurations resource represents the target database configurations. Included in the Database Security Configurations are the SQL Firewall configurations such as the status of the firewall, the time that the firewall status was last updated, violation log auto purge settings, etc.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_database_security_config_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  id varchar2(32767),
  compartment_id varchar2(32767),
  display_name varchar2(32767),
  description varchar2(32767),
  target_id varchar2(32767),
  time_created timestamp with time zone,
  time_updated timestamp with time zone,
  time_last_refreshed timestamp with time zone,
  lifecycle_state varchar2(32767),
  lifecycle_details varchar2(32767),
  sql_firewall_config dbms_cloud_oci_datasafe_sql_firewall_config_t,
  freeform_tags json_element_t,
  defined_tags json_element_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_security_config_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_security_config_summary_t (
    id varchar2,
    compartment_id varchar2,
    display_name varchar2,
    description varchar2,
    target_id varchar2,
    time_created timestamp with time zone,
    time_updated timestamp with time zone,
    time_last_refreshed timestamp with time zone,
    lifecycle_state varchar2,
    lifecycle_details varchar2,
    sql_firewall_config dbms_cloud_oci_datasafe_sql_firewall_config_t,
    freeform_tags json_element_t,
    defined_tags json_element_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Nested table type of dbms_cloud_oci_datasafe_database_security_config_summary_t.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_database_security_config_summary_tbl FORCE IS TABLE OF (dbms_cloud_oci_datasafe_database_security_config_summary_t) NOT PERSISTABLE;

Collection of database security config summaries.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_database_security_config_collection_t FORCE AUTHID CURRENT_USER IS OBJECT (
  items dbms_cloud_oci_datasafe_database_security_config_summary_tbl,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_security_config_collection_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_database_security_config_collection_t (
    items dbms_cloud_oci_datasafe_database_security_config_summary_tbl
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The Delete Rows masking format deletes the rows that meet a user-specified condition. It is useful in conditional masking when you want to delete a subset of values in a column and mask the remaining values using some other masking formats. You should be careful while using this masking format. If no condition is specified, all rows in a table are deleted. If a column is being masked using Delete Rows, there must not be a foreign key constraint or dependent column referring to the table. To learn more, check Delete Rows in the Data Safe documentation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_delete_rows_format_entry_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_format_entry_t (
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_delete_rows_format_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_delete_rows_format_entry_t (
    l_type varchar2,
    description varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_delete_rows_format_entry_t is a subtype of the dbms_cloud_oci_datasafe_format_entry_t type.

The Deterministic Encryption (Date) masking format encrypts column data using a cryptographic key and Advanced Encryption Standard (AES 128). It can be used to encrypt date columns only. It requires a range of dates as input defined by the startDate and endDate attributes. The start date must be less than or equal to the end date. The original column values in all the rows must be within the specified date range. The encrypted values are also within the specified range. Therefore, to ensure uniqueness, the total number of dates in the range must be greater than or equal to the number of distinct original values in the column. If an original value is not in the specified date range, it might not produce a one-to-one mapping. All non-confirming values are mapped to a single encrypted value, thereby producing a many-to-one mapping. Deterministic Encryption (Date) is a format-preserving, deterministic and reversible masking format, which requires a seed value while submitting a masking work request. Passing the same seed value when masking multiple times or masking different databases ensures that the data is masked deterministically. To learn more, check Deterministic Encryption in the Data Safe documentation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_deterministic_encryption_date_format_entry_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_format_entry_t (
  start_date timestamp with time zone,
  end_date timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_deterministic_encryption_date_format_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_deterministic_encryption_date_format_entry_t (
    l_type varchar2,
    description varchar2,
    start_date timestamp with time zone,
    end_date timestamp with time zone
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_deterministic_encryption_date_format_entry_t is a subtype of the dbms_cloud_oci_datasafe_format_entry_t type.

Fields

The Deterministic Encryption masking format encrypts column data using a cryptographic key and Advanced Encryption Standard (AES 128). It can be used to encrypt character and number columns. It can encrypt ASCII data without any input (except seed value), but it needs a regular expression to encrypt non-ASCII data. Deterministic Encryption is a format-preserving, deterministic and reversible masking format, which requires a seed value while submitting a masking work request. Passing the same seed value when masking multiple times or masking different databases ensures that the data is masked deterministically. To learn more, check Deterministic Encryption in the Data Safe documentation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_deterministic_encryption_format_entry_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_format_entry_t (
  regular_expression varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_deterministic_encryption_format_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_deterministic_encryption_format_entry_t (
    l_type varchar2,
    description varchar2,
    regular_expression varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_deterministic_encryption_format_entry_t is a subtype of the dbms_cloud_oci_datasafe_format_entry_t type.

Fields

The Deterministic Substitution masking format uses the specified substitution column as the source of masked values. It performs hash-based substitution to replace the original data in a column with values from the substitution column. As a masking operation renames tables temporarily, the substitution column must be in a table that has no masking column. Also, you may want to ensure that the substitution column has sufficient values to uniquely mask the target column. Deterministic Substitution requires a seed value while submitting a masking work request. Passing the same seed value when masking multiple times or masking different databases ensures that the data is masked deterministically. To learn more, check Deterministic Substitution in the Data Safe documentation.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_deterministic_substitution_format_entry_t FORCE AUTHID CURRENT_USER UNDER dbms_cloud_oci_datasafe_format_entry_t (
  schema_name varchar2(32767),
  table_name varchar2(32767),
  column_name varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_deterministic_substitution_format_entry_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_deterministic_substitution_format_entry_t (
    l_type varchar2,
    description varchar2,
    schema_name varchar2,
    table_name varchar2,
    column_name varchar2
  ) RETURN SELF AS RESULT
);

dbms_cloud_oci_datasafe_deterministic_substitution_format_entry_t is a subtype of the dbms_cloud_oci_datasafe_format_entry_t type.

Fields

A SDM masking policy difference column. It can be one of the following three types: NEW: A new column in the sensitive data model that is not in the masking policy. DELETED: A column that is present in the masking policy but has been deleted from the sensitive data model. MODIFIED: A column that is present in the masking policy as well as the sensitive data model but some of its attributes have been modified.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_difference_column_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  difference_type varchar2(32767),
  sensitive_columnkey varchar2(32767),
  masking_columnkey varchar2(32767),
  schema_name varchar2(32767),
  object_name varchar2(32767),
  column_name varchar2(32767),
  sensitive_type_id varchar2(32767),
  planned_action varchar2(32767),
  sync_status varchar2(32767),
  time_last_synced timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_difference_column_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_difference_column_t (
    key varchar2,
    difference_type varchar2,
    sensitive_columnkey varchar2,
    masking_columnkey varchar2,
    schema_name varchar2,
    object_name varchar2,
    column_name varchar2,
    sensitive_type_id varchar2,
    planned_action varchar2,
    sync_status varchar2,
    time_last_synced timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Summary of a SDM masking policy difference column.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_difference_column_summary_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  difference_type varchar2(32767),
  sensitive_columnkey varchar2(32767),
  masking_columnkey varchar2(32767),
  schema_name varchar2(32767),
  object_name varchar2(32767),
  column_name varchar2(32767),
  sensitive_type_id varchar2(32767),
  planned_action varchar2(32767),
  sync_status varchar2(32767),
  time_last_synced timestamp with time zone,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_difference_column_summary_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_difference_column_summary_t (
    key varchar2,
    difference_type varchar2,
    sensitive_columnkey varchar2,
    masking_columnkey varchar2,
    schema_name varchar2,
    object_name varchar2,
    column_name varchar2,
    sensitive_type_id varchar2,
    planned_action varchar2,
    sync_status varchar2,
    time_last_synced timestamp with time zone
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

References to the sections of STIG, CIS, and/or GDPR relevant to the current finding.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_references_t FORCE AUTHID CURRENT_USER IS OBJECT (
  stig varchar2(32767),
  cis varchar2(32767),
  gdpr varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_references_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_references_t (
    stig varchar2,
    cis varchar2,
    gdpr varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The particular finding reported by the security assessment.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_finding_t FORCE AUTHID CURRENT_USER IS OBJECT (
  key varchar2(32767),
  severity varchar2(32767),
  title varchar2(32767),
  remarks varchar2(32767),
  details json_element_t,
  summary varchar2(32767),
  references dbms_cloud_oci_datasafe_references_t,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_finding_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_finding_t (
    key varchar2,
    severity varchar2,
    title varchar2,
    remarks varchar2,
    details json_element_t,
    summary varchar2,
    references dbms_cloud_oci_datasafe_references_t
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

Results of the comparison of an item between two security assessments.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_diffs_t FORCE AUTHID CURRENT_USER IS OBJECT (
  l_current dbms_cloud_oci_datasafe_finding_t,
  baseline dbms_cloud_oci_datasafe_finding_t,
  removed_items dbms_cloud_oci_datasafe_varchar2_tbl,
  added_items dbms_cloud_oci_datasafe_varchar2_tbl,
  modified_items dbms_cloud_oci_datasafe_varchar2_tbl,
  severity varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_diffs_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_diffs_t (
    l_current dbms_cloud_oci_datasafe_finding_t,
    baseline dbms_cloud_oci_datasafe_finding_t,
    removed_items dbms_cloud_oci_datasafe_varchar2_tbl,
    added_items dbms_cloud_oci_datasafe_varchar2_tbl,
    modified_items dbms_cloud_oci_datasafe_varchar2_tbl,
    severity varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields

The scope of analytics data.

Syntax

CREATE OR REPLACE NONEDITIONABLE TYPE dbms_cloud_oci_datasafe_dimensions_t FORCE AUTHID CURRENT_USER IS OBJECT (
  target_id varchar2(32767),
  sensitive_data_model_id varchar2(32767),
  sensitive_type_id varchar2(32767),
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_dimensions_t
    RETURN SELF AS RESULT,
  CONSTRUCTOR FUNCTION dbms_cloud_oci_datasafe_dimensions_t (
    target_id varchar2,
    sensitive_data_model_id varchar2,
    sensitive_type_id varchar2
  ) RETURN SELF AS RESULT
) NOT PERSISTABLE;

Fields